DBA Data[Home] [Help]

APPS.PO_FBO_PKG dependencies on PO_LINES_ALL

Line 506: FROM po_lines_all_ext_b ple,

502: FROM (SELECT SUM(Decode(pla.matching_basis,
503: 'AMOUNT',pla.amount,
504: (pla.quantity * pla.unit_price))) total_amount,
505: c_ext_attr4
506: FROM po_lines_all_ext_b ple,
507: po_lines_all pla,
508: ego_fnd_dsc_flx_ctx_ext ego
509: WHERE pla.po_header_id = p_document_id
510: AND pla.po_line_id = ple.po_line_id

Line 507: po_lines_all pla,

503: 'AMOUNT',pla.amount,
504: (pla.quantity * pla.unit_price))) total_amount,
505: c_ext_attr4
506: FROM po_lines_all_ext_b ple,
507: po_lines_all pla,
508: ego_fnd_dsc_flx_ctx_ext ego
509: WHERE pla.po_header_id = p_document_id
510: AND pla.po_line_id = ple.po_line_id
511: AND ple.draft_id = -1

Line 588: FROM po_lines_all_ext_b ple,

584: FROM (SELECT SUM(decode(pla.matching_basis,
585: 'AMOUNT',pla.amount,
586: (pla.quantity * pla.unit_price))) total_amount,
587: c_ext_attr3
588: FROM po_lines_all_ext_b ple,
589: po_lines_all pla,
590: ego_fnd_dsc_flx_ctx_ext ego
591: WHERE pla.po_header_id = p_document_id
592: AND ple.draft_id = -1

Line 589: po_lines_all pla,

585: 'AMOUNT',pla.amount,
586: (pla.quantity * pla.unit_price))) total_amount,
587: c_ext_attr3
588: FROM po_lines_all_ext_b ple,
589: po_lines_all pla,
590: ego_fnd_dsc_flx_ctx_ext ego
591: WHERE pla.po_header_id = p_document_id
592: AND ple.draft_id = -1
593: AND pla.po_line_id = ple.po_line_id