APPS.JAI_AP_UTILS_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 1497: from po_line_locations_all

1493: where transaction_id = p_rcv_transaction_id;
1494:
1495: /* cursor c_get_po_qty_price(p_po_distribution_id number) is
1496: select price_override, quantity
1497: from po_line_locations_all
1498: where (po_header_id, po_line_id, line_location_id ) in
1499: (
1500: select po_header_id, po_line_id, line_location_id
1501: from po_distributions_all

Line 1507: from po_line_locations_all

1503: ); */
1504: /*bug 9346307*/
1505: cursor c_get_po_qty_price is
1506: select price_override, quantity
1507: from po_line_locations_all
1508: where (po_header_id, po_line_id, line_location_id ) in
1509: (
1510: select po_header_id, po_line_id, po_line_location_id
1511: from ap_invoice_lines_all

Line 1558: v_po_price po_line_locations_all.price_override%type;

1554: v_receipt_uom rcv_transactions.unit_of_measure%type;
1555:
1556: v_receipt_quantity JAI_RCV_LINES.qty_received%type;
1557:
1558: v_po_price po_line_locations_all.price_override%type;
1559: v_po_quantity po_line_locations_all.quantity%type;
1560:
1561: v_po_distribution_id ap_invoice_distributions_all.po_distribution_id%type;
1562: v_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%type;

Line 1559: v_po_quantity po_line_locations_all.quantity%type;

1555:
1556: v_receipt_quantity JAI_RCV_LINES.qty_received%type;
1557:
1558: v_po_price po_line_locations_all.price_override%type;
1559: v_po_quantity po_line_locations_all.quantity%type;
1560:
1561: v_po_distribution_id ap_invoice_distributions_all.po_distribution_id%type;
1562: v_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%type;
1563:

Line 3173: po_line_locations_all ploc

3169: INTO
3170: ln_inv_org_id
3171: , lv_inv_org_code
3172: FROM
3173: po_line_locations_all ploc
3174: , mtl_parameters mp
3175: WHERE ploc.line_location_id = ln_po_loc_id
3176: AND ploc.ship_to_organization_id = mp.organization_id;
3177: END IF; -- ln_po_dist_id IS NULL