[Home] [Help]
1728: END IF;
1729:
1730: -- bug 5061826
1731: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1732: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1733:
1734: INSERT INTO AP_INVOICE_LINES (
1735: INVOICE_ID,
1736: LINE_NUMBER,
2113: and msi.inventory_item_id(+) = pl.item_id
2114: and msi.organization_id(+) = g_inventory_organization_id
2115: and rownum = 1;
2116: /* -- bug 5061826 -- commented out older FROM clause
2117: FROM PO_LINE_LOCATIONS_AP_V PLL,
2118: PO_DISTRIBUTIONS_AP_V PD,
2119: MTL_SYSTEM_ITEMS MSI
2120: WHERE PLL.LINE_LOCATION_ID = X_PO_LINE_LOCATION_ID
2121: AND PD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
4372: AIL.USER_DEFINED_FISC_CLASS, --user_defined_fisc_class
4373: g_pay_awt_group_id --pay_awt_group_id bug8222382
4374: FROM ap_invoices ai,
4375: ap_invoice_lines ail,
4376: po_line_locations_ap_v pll
4377: WHERE ai.invoice_id = x_corrected_invoice_id
4378: AND ail.invoice_id = ai.invoice_id
4379: AND ail.line_number = x_corrected_line_number
4380: AND pll.line_location_id = ail.po_line_location_id;
4991: pll.product_type product_type,
4992: pll.product_category product_category,
4993: pll.user_defined_fisc_class user_defined_fisc_class
4994: */
4995: FROM po_line_locations_ap_v pll,
4996: mtl_system_items msi
4997: WHERE pll.po_header_id = x_po_header_id
4998: AND msi.inventory_item_id(+) = pll.item_id
4999: AND msi.organization_id(+) = g_inventory_organization_id