APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_LOOKUP_CODES

Line 8063: FROM PO_LOOKUP_CODES

8059: FROM PO_HEADERS_GT POH
8060: WHERE POH.po_header_id = p_document_id
8061: AND POH.type_lookup_code = 'STANDARD'
8062: AND Nvl(POH.clm_award_type,'N') IN (SELECT lookup_code
8063: FROM PO_LOOKUP_CODES
8064: WHERE lookup_type = 'PO_CLM_AWD_TYPE_ORD_OFF_IDV')
8065: AND POH.clm_source_document_id IS NULL
8066: AND POH.clm_external_idv IS NULL
8067: AND nvl(l_clm_po,'N') = 'Y';

Line 8104: FROM PO_LOOKUP_CODES

8100: FROM PO_HEADERS_GT POH
8101: WHERE POH.po_header_id = p_document_id
8102: AND POH.type_lookup_code = 'STANDARD'
8103: AND Nvl(POH.clm_award_type,'N') IN (SELECT lookup_code
8104: FROM PO_LOOKUP_CODES
8105: WHERE lookup_type = 'PO_CLM_AWD_TYPE_SPO')
8106: AND (POH.clm_source_document_id IS NOT NULL
8107: OR
8108: POH.clm_external_idv IS NOT NULL )

Line 24869: po_lookup_codes plc

24865: 'PO_PAY_INSTR_CHANGED_TO_MANUAL',
24866: 'W'
24867: FROM po_headers_gt POH,
24868: po_headers_all POH1,
24869: po_lookup_codes plc
24870: WHERE POH.po_header_id = p_document_id
24871: AND POH1.po_header_id = POH.po_header_id
24872: AND NVL(POH.clm_payment_instr_code, 'null') <> NVL(POH1.clm_payment_instr_code, 'null')
24873: AND ( NVL(POH.clm_payment_instr_code, 'null') = 'KO_SPECIFIED'

Line 24914: po_lookup_codes plc

24910: 'PO_PAY_INSTR_CHANGED_TO_MANUAL',
24911: 'W'
24912: FROM po_lines_gt POL,
24913: po_lines_all POL1,
24914: po_lookup_codes plc
24915: WHERE POL.po_header_id = p_document_id
24916: AND POL1.po_header_id = POL.po_header_id
24917: AND POL1.po_line_id = POL.po_line_id
24918: AND NVL(POL.clm_payment_instr_code, 'null') <> NVL(POL1.clm_payment_instr_code, 'null')