[Home] [Help]
183: G_Expenditure_Type pa_expenditure_types.expenditure_type%TYPE;
184: G_Invoice_Date ap_invoices.invoice_date%TYPE;
185: G_Expenditure_Organization_ID pa_exp_orgs_it.organization_id%TYPE;
186: G_Asset_Book_Type_Code fa_book_controls.book_type_code%TYPE;
187: G_Asset_Category_Id mtl_system_items.asset_category_id%TYPE;
188: G_Inventory_Organization_Id financials_system_parameters.inventory_organization_id%TYPE;
189: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
190: -- Removed for bug 4277744
191: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE;
2104: -- bug 5061826 -- new FROM clause that goes to base tables
2105: FROM PO_LINES_ALL PL,
2106: PO_LINE_LOCATIONS_ALL PLL,
2107: po_distributions pd,
2108: mtl_system_items msi
2109: WHERE pll.line_location_id = x_po_line_location_id
2110: and pd.line_location_id = pll.line_location_id
2111: AND PLL.PO_LINE_ID = PL.PO_LINE_ID
2112: and pd.po_distribution_id = nvl(x_po_distribution_id,pd.po_distribution_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
2122: AND PD.PO_DISTRIBUTION_ID = NVL(X_PO_DISTRIBUTION_ID,PD.PO_DISTRIBUTION_ID)
2123: AND MSI.INVENTORY_ITEM_ID(+) = PLL.ITEM_ID
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
5000: AND pll.match_option = 'P'
5082: rcv.product_category product_category,
5083: rcv.user_defined_fisc_class user_defined_fisc_class
5084: */
5085: FROM po_ap_receipt_match_v rcv,
5086: mtl_system_items msi,
5087: rcv_shipment_lines rsl
5088: WHERE rcv.po_header_id = x_po_header_id
5089: AND msi.inventory_item_id(+) = rcv.item_id
5090: AND msi.organization_id(+) = g_inventory_organization_id
5107: l_item_id po_lines.item_id%TYPE;
5108: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5109: l_price_override po_line_locations.price_override%TYPE;
5110: l_item_description po_lines.item_description%TYPE;
5111: l_asset_category_id mtl_system_items.asset_category_id%TYPE;
5112: -- Removed for bug 4277744
5113: -- l_ussgl_transaction_code po_line_locations.ussgl_transaction_code%TYPE;
5114: l_type_1099 po_lines.type_1099%TYPE;
5115: l_attribute_category po_line_locations.attribute_category%TYPE;