[Home] [Help]
324: C_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
325: C_Invoice_line_number ap_invoice_lines_all.line_number%TYPE;
326: C_Price NUMBER;
327: C_Description ap_lookup_codes.description%TYPE;
328: C_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
329: C_inventory_org_id financials_system_parameters.inventory_organization_id%TYPE;
330: C_asset_bt_code AP_INVOICE_LINES_ALL.ASSET_BOOK_TYPE_CODE%TYPE;
331: C_dist_tab AP_MATCHING_PKG.dist_tab_type;
332: C_ship_to_location_id PO_VENDOR_SITES.ship_to_location_id%TYPE;
887: pll.matching_basis
888: INTO P_price,
889: P_unit_meas_lookup_code,
890: l_matching_basis /* bug 5228301 */
891: FROM po_line_locations pll, po_lines pl, po_line_types plt
892: WHERE pll.line_location_id = P_po_shipment_id
893: AND pl.po_line_id = pll.po_line_id
894: AND pl.line_type_id = plt.line_type_id;
895:
925: (sum(nvl(pd.amount_ordered,0) - nvl(pd.amount_billed,0) -
926: nvl(pd.amount_cancelled,0)) - (p_invoice_amount - nvl(p_tax_amount,0)))
927: )
928: INTO C_quantity_outstanding
929: FROM po_distributions_ap_v pd,po_line_locations pll
930: WHERE pd.line_location_id=pll.line_location_id
931: AND pd.line_location_id = P_po_shipment_id
932: GROUP BY pll.line_location_id,pll.price_override;
933:
2319: PLL.SHIP_TO_LOCATION_ID, --ship_to_location_id
2320: p_retained_amount, --retained_amount /* bug 5228301 */
2321: (-1)*p_retained_amount, --retained_amount_reamining
2322: p_tax_classification_code --tax_classification_code
2323: FROM PO_LINE_LOCATIONS_AP_V PLL,
2324: MTL_SYSTEM_ITEMS MSI
2325: WHERE PLL.LINE_LOCATION_ID = P_PO_LINE_LOCATION_ID
2326: AND MSI.INVENTORY_ITEM_ID(+) = PLL.ITEM_ID
2327: AND MSI.ORGANIZATION_ID(+) = P_INVENTORY_ORG_ID;