[Home] [Help]
820: ap_invoice_lines_all APIL,
821: ap_invoices_all API,
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,
1325: ap_invoices_all API,
1326: AP_PAYMENT_HIST_DISTS APHD, --Bug9967535
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,
1786: ap_invoice_payments_all APIP,
1787: ap_payment_hist_dists APHD,
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,
2064: AND APID.assets_tracking_flag = 'Y'
2065: AND EXISTS -- Added EXISTS for bug 9669334
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
2097: AND APID.assets_tracking_flag = 'Y'
2098: AND EXISTS -- Added EXISTS for bug 9669334
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