[Home] [Help]
330: C_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
331: C_Invoice_line_number ap_invoice_lines_all.line_number%TYPE;
332: C_Price NUMBER;
333: C_Description ap_lookup_codes.description%TYPE;
334: C_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
335: C_inventory_org_id financials_system_parameters.inventory_organization_id%TYPE;
336: C_asset_bt_code AP_INVOICE_LINES_ALL.ASSET_BOOK_TYPE_CODE%TYPE;
337: C_dist_tab AP_MATCHING_PKG.dist_tab_type;
338: C_ship_to_location_id PO_VENDOR_SITES.ship_to_location_id%TYPE;
911: pll.matching_basis
912: INTO P_price,
913: P_unit_meas_lookup_code,
914: l_matching_basis /* bug 5228301 */
915: FROM po_line_locations pll, po_lines pl, po_line_types plt
916: WHERE pll.line_location_id = P_po_shipment_id
917: AND pl.po_line_id = pll.po_line_id
918: AND pl.line_type_id = plt.line_type_id;
919:
949: (sum(nvl(pd.amount_ordered,0) - nvl(pd.amount_billed,0) -
950: nvl(pd.amount_cancelled,0)) - (p_invoice_amount - nvl(p_tax_amount,0)))
951: )
952: INTO C_quantity_outstanding
953: FROM po_distributions_ap_v pd,po_line_locations pll
954: WHERE pd.line_location_id=pll.line_location_id
955: AND pd.line_location_id = P_po_shipment_id
956: GROUP BY pll.line_location_id,pll.price_override;
957:
2350: p_tax_classification_code, --tax_classification_code
2351: --Added below 2 columns forBug#8640313
2352: P_PRODUCT_TYPE, --Product_type
2353: P_PRODUCT_CATEGORY --Product_category
2354: FROM PO_LINE_LOCATIONS_AP_V PLL,
2355: MTL_SYSTEM_ITEMS MSI
2356: WHERE PLL.LINE_LOCATION_ID = P_PO_LINE_LOCATION_ID
2357: AND MSI.INVENTORY_ITEM_ID(+) = PLL.ITEM_ID
2358: AND MSI.ORGANIZATION_ID(+) = P_INVENTORY_ORG_ID;