DBA Data[Home] [Help]

APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on PO_LINES_ALL

Line 826: po_lines_all POL,

822: financials_system_params_all FSP, -- changed table order # 9669334
823: ap_batches_all APB,
824: po_distributions_all POD,
825: po_headers_all POH,
826: po_lines_all POL,
827: po_vendors POV,
828: po_line_types_b POLT,
829: -- mtl_system_items MTLSI,
830: xla_distribution_links XDL,

Line 1331: po_lines_all POL,

1327: financials_system_params_all FSP, -- changed table order # 9669334
1328: ap_batches_all APB,
1329: po_distributions_all POD,
1330: po_headers_all POH,
1331: po_lines_all POL,
1332: po_vendors POV,
1333: po_line_types_b POLT,
1334: -- mtl_system_items MTLSI,
1335: xla_distribution_links XDL,

Line 1792: --po_lines_all POL, /*Bug12703009: Commented the unused table*/

1788: ap_invoices_all API,
1789: ap_batches_all APB,
1790: po_distributions_all POD,
1791: po_headers_all POH,
1792: --po_lines_all POL, /*Bug12703009: Commented the unused table*/
1793: po_vendors POV,
1794: --po_line_types_b POLT,
1795: xla_distribution_links XDL,
1796: xla_ae_headers XAH,

Line 2070: po_lines_all POL

2066: (SELECT 'X'
2067: FROM mtl_system_items MTLSI,
2068: po_distributions_all POD,
2069: po_line_locations_all PLL,
2070: po_lines_all POL
2071: WHERE POD.po_distribution_id = APID.po_distribution_id
2072: AND PLL.line_location_id = POD.line_location_id
2073: AND POL.po_line_id = PLL.po_line_id
2074: AND POL.item_id = MTLSI.inventory_item_id

Line 2103: po_lines_all POL

2099: (SELECT 'X'
2100: FROM mtl_system_items MTLSI,
2101: po_distributions_all POD,
2102: po_line_locations_all PLL,
2103: po_lines_all POL
2104: WHERE POD.po_distribution_id = APID.po_distribution_id
2105: AND PLL.line_location_id = POD.line_location_id
2106: AND POL.po_line_id = PLL.po_line_id
2107: AND POL.item_id = MTLSI.inventory_item_id