DBA Data[Home] [Help]

APPS.CSTPPIPV dependencies on PO_LINES_ALL

Line 123: po_lines_all pla

119: ( SELECT 'X'
120: FROM ap_invoice_distributions_all aida,
121: po_distributions_all pda,
122: po_line_locations_all plla,
123: po_lines_all pla
124: WHERE aida.po_distribution_id = pda.po_distribution_id
125: AND aida.posted_flag = 'Y'
126: --AND NVL(aida.reversal_flag,'N') <> 'Y'
127: AND aida.accounting_date <= l_cutoff_date

Line 803: po_lines_all pla,

799: pla.item_id inventory_item_id,
800: pda.project_id
801: FROM po_distributions_all pda,
802: po_line_locations_all plla,
803: po_lines_all pla,
804: wip_entities we,
805: wip_discrete_jobs wdj
806: WHERE ( ( ( p_item_type = 1 -- OSP and direct
807: OR p_item_type = 2) -- OSP only

Line 1756: po_lines_all pla

1752: /* changes for performance improvement bug4873742 */
1753: AND EXISTS (
1754: SELECT 'X'
1755: FROM po_line_locations_all plla,
1756: po_lines_all pla
1757: WHERE pla.po_line_id = plla.po_line_id
1758: AND pla.item_id = p_inventory_item_id
1759: AND nvl(plla.lcm_flag,'N') = 'N'
1760: AND pda.line_location_id = plla.line_location_id)