1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| PROCEDURE GET_THE_DET_FCO (IDFCO IN VARCHAR2 ,
IO_CURSOR IN OUT GET_THE_DET_FCO_CUR ) IS
C_GET_THE_DET_FCO GET_THE_DET_FCO_CUR;
BEGIN
OPEN C_GET_THE_DET_FCO FOR
' SELECT t1.FCOREC_FCO_CODE_FK_PK FCOID, '||
' ''0.''||t1.FCOREC_NUMORD GRP, '||
' t2.CDF_NOM INFO_01 , '||
' t2.CDF_DATECR DAT_CRE , '||
' t2.CDF_DATEMJ DAT_MAJ '||
' FROM FCOREC_FCO_REC t1 , '||
' CDF_CODIF t2 '||
' WHERE t1.FCOREC_CDF_REC_CODE_FK_PK = t2.CDF_CODE_PK '||
' AND t2.CDF_NUMERO_PK = ''CC'' '||
' AND t1.FCOREC_FCO_CODE_FK_PK IN ('||IDFCO||')' ||
' UNION '||
' SELECT t1.FCOCOM_FCO_CODE_FK_PK FCOID, '||
' ''1.''||t1.FCOCOM_NUMORD GRP, '||
' t2.CDF_NOM INFO_01 , '||
' t2.CDF_DATECR DAT_CRE , '||
' t2.CDF_DATEMJ DAT_MAJ '||
' FROM FCOCOM_FCO_COM t1 , '||
' CDF_CODIF t2 '||
' WHERE t1.FCOCOM_CDF_COM_CODE_FK_PK = t2.CDF_CODE_PK '||
' AND t2.CDF_NUMERO_PK = ''CC'' '||
' AND t1.FCOCOM_FCO_CODE_FK_PK IN ('||IDFCO||')' ||
' ORDER BY 1 ';
IO_CURSOR := C_GET_THE_DET_FCO ;
END GET_THE_DET_FCO ; |
Partager