[Home] [Help]
1827: --End Bug#13505998
1828:
1829: -- bug 5061826
1830: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1831: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1832:
1833: INSERT INTO AP_INVOICE_LINES (
1834: INVOICE_ID,
1835: LINE_NUMBER,
2213: and msi.inventory_item_id(+) = pl.item_id
2214: and msi.organization_id(+) = g_inventory_organization_id
2215: and rownum = 1;
2216: /* -- bug 5061826 -- commented out older FROM clause
2217: FROM PO_LINE_LOCATIONS_AP_V PLL,
2218: PO_DISTRIBUTIONS_AP_V PD,
2219: MTL_SYSTEM_ITEMS MSI
2220: WHERE PLL.LINE_LOCATION_ID = X_PO_LINE_LOCATION_ID
2221: AND PD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
4486: AIL.USER_DEFINED_FISC_CLASS, --user_defined_fisc_class
4487: g_pay_awt_group_id --pay_awt_group_id bug8222382
4488: FROM ap_invoices ai,
4489: ap_invoice_lines ail,
4490: po_line_locations_ap_v pll
4491: WHERE ai.invoice_id = x_corrected_invoice_id
4492: AND ail.invoice_id = ai.invoice_id
4493: AND ail.line_number = x_corrected_line_number
4494: AND pll.line_location_id = ail.po_line_location_id;
5115: pll.product_type product_type,
5116: pll.product_category product_category,
5117: pll.user_defined_fisc_class user_defined_fisc_class
5118: */
5119: FROM po_line_locations_ap_v pll,
5120: mtl_system_items msi
5121: WHERE pll.po_header_id = x_po_header_id
5122: AND msi.inventory_item_id(+) = pll.item_id
5123: AND msi.organization_id(+) = g_inventory_organization_id