VIEW: APPS.IGC_CBC_PO_PROCESS_EXCEPTION_V

Source

View Text - Preformatted

SELECT FND.MEANING DOCUMENT_TYPE, PO_HDR.SEGMENT1 DOCUMENT_NUMBER, NULL RELEASE_NUM, To_Char(PO_LINE.LINE_NUM) LINE_NUM, To_Char(PO_LOC.SHIPMENT_NUM) SHIPMENT_NUM, To_Char(PO_DIST.DISTRIBUTION_NUM) DISTRIBUTION_NUM, EXC.EXCEPTION_REASON EXCEPTION_REASON, EXC.CONC_REQUEST_ID CONC_REQUEST_ID, EXC.PROCESS_PHASE PROCESS_PHASE, EXC.PROCESS_TYPE PROCESS_TYPE, EXC.DOCUMENT_ID, EXC.LINE_ID, EXC.LINE_LOCATION_ID, EXC.DISTRIBUTION_ID FROM FND_LOOKUPS FND, IGC_CBC_PO_PROCESS_EXCPTS EXC, PO_HEADERS PO_HDR, PO_LINES PO_LINE, PO_LINE_LOCATIONS PO_LOC, PO_DISTRIBUTIONS PO_DIST WHERE EXC.DOCUMENT_TYPE IN ( 'PO', 'PA') AND EXC.DOCUMENT_ID = PO_HDR.PO_HEADER_ID (+) AND EXC.LINE_ID = PO_LINE.PO_LINE_ID (+) AND EXC.LINE_LOCATION_ID = PO_LOC.LINE_LOCATION_ID (+) AND EXC.DISTRIBUTION_ID = PO_DIST.PO_DISTRIBUTION_ID (+) AND FND.LOOKUP_TYPE = 'IGC_DOCUMENT_TYPES' AND FND.LOOKUP_CODE = EXC.DOCUMENT_TYPE UNION SELECT FND.MEANING DOCUMENT_TYPE, REQ_HDR.SEGMENT1 DOCUMENT_NUMBER, NULL RELEASE_NUM, To_Char(REQ_LINE.LINE_NUM) LINE_NUM, NULL SHIPMENT_NUM, To_Char(REQ_DIST.DISTRIBUTION_NUM) DISTRIBUTION_NUM, EXC.EXCEPTION_REASON EXCEPTION_REASON, EXC.CONC_REQUEST_ID CONC_REQUEST_ID, EXC.PROCESS_PHASE PROCESS_PHASE, EXC.PROCESS_TYPE PROCESS_TYPE, EXC.DOCUMENT_ID, EXC.LINE_ID, EXC.LINE_LOCATION_ID, EXC.DISTRIBUTION_ID FROM FND_LOOKUPS FND, IGC_CBC_PO_PROCESS_EXCPTS EXC, PO_REQUISITION_HEADERS REQ_HDR, PO_REQUISITION_LINES REQ_LINE, PO_REQ_DISTRIBUTIONS REQ_DIST WHERE EXC.DOCUMENT_TYPE = 'REQ' AND EXC.DOCUMENT_ID =REQ_HDR.REQUISITION_HEADER_ID (+) AND EXC.LINE_ID = REQ_LINE.REQUISITION_LINE_ID (+) AND EXC.DISTRIBUTION_ID =REQ_DIST.DISTRIBUTION_ID (+) AND FND.LOOKUP_TYPE = 'IGC_DOCUMENT_TYPES' AND FND.LOOKUP_CODE = EXC.DOCUMENT_TYPE UNION SELECT FND.MEANING DOCUMENT_TYPE, PO_HDR.SEGMENT1 DOCUMENT_NUMBER, To_Char(REL_HDR.RELEASE_NUM) RELEASE_NUM, NULL LINE_NUM, To_Char(REL_LOC.SHIPMENT_NUM) SHIPMENT_NUM, To_Char(REL_DIST.DISTRIBUTION_NUM) DISTRIBUTION_NUM, EXC.EXCEPTION_REASON EXCEPTION_REASON, EXC.CONC_REQUEST_ID CONC_REQUEST_ID, EXC.PROCESS_PHASE PROCESS_PHASE, EXC.PROCESS_TYPE PROCESS_TYPE, EXC.DOCUMENT_ID, EXC.LINE_ID, EXC.LINE_LOCATION_ID, EXC.DISTRIBUTION_ID FROM FND_LOOKUPS FND, IGC_CBC_PO_PROCESS_EXCPTS EXC, PO_HEADERS PO_HDR, PO_LINE_LOCATIONS REL_LOC, PO_DISTRIBUTIONS REL_DIST, PO_RELEASES REL_HDR WHERE EXC.DOCUMENT_TYPE = 'REL' AND EXC.DOCUMENT_ID = REL_HDR.PO_RELEASE_ID (+) AND REL_HDR.PO_HEADER_ID = PO_HDR.PO_HEADER_ID AND EXC.LINE_LOCATION_ID = REL_LOC.LINE_LOCATION_ID (+) AND EXC.DISTRIBUTION_ID = REL_DIST.PO_DISTRIBUTION_ID (+) AND FND.LOOKUP_TYPE = 'IGC_DOCUMENT_TYPES' AND FND.LOOKUP_CODE = EXC.DOCUMENT_TYPE UNION SELECT NULL DOCUMENT_TYPE, NULL DOCUMENT_NUMBER, NULL RELEASE_NUM, NULL LINE_NUM, NULL SHIPMENT_NUM, NULL DISTRIBUTION_NUM, EXC.EXCEPTION_REASON EXCEPTION_REASON, EXC.CONC_REQUEST_ID CONC_REQUEST_ID, EXC.PROCESS_PHASE PROCESS_PHASE, EXC.PROCESS_TYPE PROCESS_TYPE, EXC.DOCUMENT_ID, EXC.LINE_ID, EXC.LINE_LOCATION_ID, EXC.DISTRIBUTION_ID FROM IGC_CBC_PO_PROCESS_EXCPTS EXC WHERE EXC.DOCUMENT_TYPE IS NULL

View Text - HTML Formatted

SELECT FND.MEANING DOCUMENT_TYPE
, PO_HDR.SEGMENT1 DOCUMENT_NUMBER
, NULL RELEASE_NUM
, TO_CHAR(PO_LINE.LINE_NUM) LINE_NUM
, TO_CHAR(PO_LOC.SHIPMENT_NUM) SHIPMENT_NUM
, TO_CHAR(PO_DIST.DISTRIBUTION_NUM) DISTRIBUTION_NUM
, EXC.EXCEPTION_REASON EXCEPTION_REASON
, EXC.CONC_REQUEST_ID CONC_REQUEST_ID
, EXC.PROCESS_PHASE PROCESS_PHASE
, EXC.PROCESS_TYPE PROCESS_TYPE
, EXC.DOCUMENT_ID
, EXC.LINE_ID
, EXC.LINE_LOCATION_ID
, EXC.DISTRIBUTION_ID
FROM FND_LOOKUPS FND
, IGC_CBC_PO_PROCESS_EXCPTS EXC
, PO_HEADERS PO_HDR
, PO_LINES PO_LINE
, PO_LINE_LOCATIONS PO_LOC
, PO_DISTRIBUTIONS PO_DIST
WHERE EXC.DOCUMENT_TYPE IN ( 'PO'
, 'PA')
AND EXC.DOCUMENT_ID = PO_HDR.PO_HEADER_ID (+)
AND EXC.LINE_ID = PO_LINE.PO_LINE_ID (+)
AND EXC.LINE_LOCATION_ID = PO_LOC.LINE_LOCATION_ID (+)
AND EXC.DISTRIBUTION_ID = PO_DIST.PO_DISTRIBUTION_ID (+)
AND FND.LOOKUP_TYPE = 'IGC_DOCUMENT_TYPES'
AND FND.LOOKUP_CODE = EXC.DOCUMENT_TYPE UNION SELECT FND.MEANING DOCUMENT_TYPE
, REQ_HDR.SEGMENT1 DOCUMENT_NUMBER
, NULL RELEASE_NUM
, TO_CHAR(REQ_LINE.LINE_NUM) LINE_NUM
, NULL SHIPMENT_NUM
, TO_CHAR(REQ_DIST.DISTRIBUTION_NUM) DISTRIBUTION_NUM
, EXC.EXCEPTION_REASON EXCEPTION_REASON
, EXC.CONC_REQUEST_ID CONC_REQUEST_ID
, EXC.PROCESS_PHASE PROCESS_PHASE
, EXC.PROCESS_TYPE PROCESS_TYPE
, EXC.DOCUMENT_ID
, EXC.LINE_ID
, EXC.LINE_LOCATION_ID
, EXC.DISTRIBUTION_ID
FROM FND_LOOKUPS FND
, IGC_CBC_PO_PROCESS_EXCPTS EXC
, PO_REQUISITION_HEADERS REQ_HDR
, PO_REQUISITION_LINES REQ_LINE
, PO_REQ_DISTRIBUTIONS REQ_DIST
WHERE EXC.DOCUMENT_TYPE = 'REQ'
AND EXC.DOCUMENT_ID =REQ_HDR.REQUISITION_HEADER_ID (+)
AND EXC.LINE_ID = REQ_LINE.REQUISITION_LINE_ID (+)
AND EXC.DISTRIBUTION_ID =REQ_DIST.DISTRIBUTION_ID (+)
AND FND.LOOKUP_TYPE = 'IGC_DOCUMENT_TYPES'
AND FND.LOOKUP_CODE = EXC.DOCUMENT_TYPE UNION SELECT FND.MEANING DOCUMENT_TYPE
, PO_HDR.SEGMENT1 DOCUMENT_NUMBER
, TO_CHAR(REL_HDR.RELEASE_NUM) RELEASE_NUM
, NULL LINE_NUM
, TO_CHAR(REL_LOC.SHIPMENT_NUM) SHIPMENT_NUM
, TO_CHAR(REL_DIST.DISTRIBUTION_NUM) DISTRIBUTION_NUM
, EXC.EXCEPTION_REASON EXCEPTION_REASON
, EXC.CONC_REQUEST_ID CONC_REQUEST_ID
, EXC.PROCESS_PHASE PROCESS_PHASE
, EXC.PROCESS_TYPE PROCESS_TYPE
, EXC.DOCUMENT_ID
, EXC.LINE_ID
, EXC.LINE_LOCATION_ID
, EXC.DISTRIBUTION_ID
FROM FND_LOOKUPS FND
, IGC_CBC_PO_PROCESS_EXCPTS EXC
, PO_HEADERS PO_HDR
, PO_LINE_LOCATIONS REL_LOC
, PO_DISTRIBUTIONS REL_DIST
, PO_RELEASES REL_HDR
WHERE EXC.DOCUMENT_TYPE = 'REL'
AND EXC.DOCUMENT_ID = REL_HDR.PO_RELEASE_ID (+)
AND REL_HDR.PO_HEADER_ID = PO_HDR.PO_HEADER_ID
AND EXC.LINE_LOCATION_ID = REL_LOC.LINE_LOCATION_ID (+)
AND EXC.DISTRIBUTION_ID = REL_DIST.PO_DISTRIBUTION_ID (+)
AND FND.LOOKUP_TYPE = 'IGC_DOCUMENT_TYPES'
AND FND.LOOKUP_CODE = EXC.DOCUMENT_TYPE UNION SELECT NULL DOCUMENT_TYPE
, NULL DOCUMENT_NUMBER
, NULL RELEASE_NUM
, NULL LINE_NUM
, NULL SHIPMENT_NUM
, NULL DISTRIBUTION_NUM
, EXC.EXCEPTION_REASON EXCEPTION_REASON
, EXC.CONC_REQUEST_ID CONC_REQUEST_ID
, EXC.PROCESS_PHASE PROCESS_PHASE
, EXC.PROCESS_TYPE PROCESS_TYPE
, EXC.DOCUMENT_ID
, EXC.LINE_ID
, EXC.LINE_LOCATION_ID
, EXC.DISTRIBUTION_ID
FROM IGC_CBC_PO_PROCESS_EXCPTS EXC
WHERE EXC.DOCUMENT_TYPE IS NULL