[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;
2204: -- bug 5061826 -- new FROM clause that goes to base tables
2205: FROM PO_LINES_ALL PL,
2206: PO_LINE_LOCATIONS_ALL PLL,
2207: po_distributions pd,
2208: mtl_system_items msi
2209: WHERE pll.line_location_id = x_po_line_location_id
2210: and pd.line_location_id = pll.line_location_id
2211: AND PLL.PO_LINE_ID = PL.PO_LINE_ID
2212: and pd.po_distribution_id = nvl(x_po_distribution_id,pd.po_distribution_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
2222: AND PD.PO_DISTRIBUTION_ID = NVL(X_PO_DISTRIBUTION_ID,PD.PO_DISTRIBUTION_ID)
2223: AND MSI.INVENTORY_ITEM_ID(+) = PLL.ITEM_ID
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
5124: AND pll.match_option = 'P'
5207: rcv.product_category product_category,
5208: rcv.user_defined_fisc_class user_defined_fisc_class
5209: */
5210: FROM po_ap_receipt_match_v rcv,
5211: mtl_system_items msi,
5212: rcv_shipment_lines rsl
5213: WHERE rcv.po_header_id = x_po_header_id
5214: AND msi.inventory_item_id(+) = rcv.item_id
5215: AND msi.organization_id(+) = g_inventory_organization_id
5232: l_item_id po_lines.item_id%TYPE;
5233: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5234: l_price_override po_line_locations.price_override%TYPE;
5235: l_item_description po_lines.item_description%TYPE;
5236: l_asset_category_id mtl_system_items.asset_category_id%TYPE;
5237: -- Removed for bug 4277744
5238: -- l_ussgl_transaction_code po_line_locations.ussgl_transaction_code%TYPE;
5239: l_type_1099 po_lines.type_1099%TYPE;
5240: l_attribute_category po_line_locations.attribute_category%TYPE;