DBA Data[Home] [Help]

APPS.JAI_AP_UTILS_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 1286: from po_line_locations_all

1282: where transaction_id = p_rcv_transaction_id;
1283:
1284: cursor c_get_po_qty_price(p_po_distribution_id number) is
1285: select price_override, quantity
1286: from po_line_locations_all
1287: where (po_header_id, po_line_id, line_location_id ) in
1288: (
1289: select po_header_id, po_line_id, line_location_id
1290: from po_distributions_all

Line 1336: v_po_price po_line_locations_all.price_override%type;

1332: v_receipt_uom rcv_transactions.unit_of_measure%type;
1333:
1334: v_receipt_quantity JAI_RCV_LINES.qty_received%type;
1335:
1336: v_po_price po_line_locations_all.price_override%type;
1337: v_po_quantity po_line_locations_all.quantity%type;
1338:
1339: v_po_distribution_id ap_invoice_distributions_all.po_distribution_id%type;
1340: v_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%type;

Line 1337: v_po_quantity po_line_locations_all.quantity%type;

1333:
1334: v_receipt_quantity JAI_RCV_LINES.qty_received%type;
1335:
1336: v_po_price po_line_locations_all.price_override%type;
1337: v_po_quantity po_line_locations_all.quantity%type;
1338:
1339: v_po_distribution_id ap_invoice_distributions_all.po_distribution_id%type;
1340: v_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%type;
1341:

Line 2948: po_line_locations_all ploc

2944: INTO
2945: ln_inv_org_id
2946: , lv_inv_org_code
2947: FROM
2948: po_line_locations_all ploc
2949: , mtl_parameters mp
2950: WHERE ploc.line_location_id = ln_po_loc_id
2951: AND ploc.ship_to_organization_id = mp.organization_id;
2952: END IF; -- ln_po_dist_id IS NULL