eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RCV_STD_RCPT_APIS dependencies on RCV_LOTS_SUPPLY

Line 9096: l_rlsu_quantity RCV_LOTS_SUPPLY.QUANTITY%TYPE := 0;

9092: , p_rcv_org_id IN NUMBER
9093: , x_return_status OUT NOCOPY VARCHAR2
9094: )
9095: IS
9096: l_rlsu_quantity RCV_LOTS_SUPPLY.QUANTITY%TYPE := 0;
9097: l_rlsu_primary_quantity RCV_LOTS_SUPPLY.PRIMARY_QUANTITY%TYPE := 0;
9098: l_index NUMBER := 0;
9099: l_diff_txn_qty NUMBER := 0;
9100: l_partial_rcpt NUMBER := 0;

Line 9097: l_rlsu_primary_quantity RCV_LOTS_SUPPLY.PRIMARY_QUANTITY%TYPE := 0;

9093: , x_return_status OUT NOCOPY VARCHAR2
9094: )
9095: IS
9096: l_rlsu_quantity RCV_LOTS_SUPPLY.QUANTITY%TYPE := 0;
9097: l_rlsu_primary_quantity RCV_LOTS_SUPPLY.PRIMARY_QUANTITY%TYPE := 0;
9098: l_index NUMBER := 0;
9099: l_diff_txn_qty NUMBER := 0;
9100: l_partial_rcpt NUMBER := 0;
9101: l_rec_count NUMBER := 0;

Line 9155: FROM rcv_lots_supply rlsu,

9151: SELECT NVL(SUM(rlsu.quantity),0) ,
9152: NVL(SUM(rlsu.primary_quantity),0)
9153: INTO l_rlsu_quantity,
9154: l_rlsu_primary_quantity
9155: FROM rcv_lots_supply rlsu,
9156: rcv_shipment_lines rsl
9157: WHERE rlsu.shipment_line_id = rsl.shipment_line_id
9158: AND rsl.item_id = p_inventory_item_id
9159: AND rsl.to_organization_id = p_rcv_org_id

Line 9227: l_rlsu_primary_quantity RCV_LOTS_SUPPLY.PRIMARY_QUANTITY%TYPE := 0;

9223: , p_rcv_org_id IN NUMBER
9224: , p_product_txn_id IN NUMBER
9225: , x_return_status OUT NOCOPY VARCHAR2
9226: ) IS
9227: l_rlsu_primary_quantity RCV_LOTS_SUPPLY.PRIMARY_QUANTITY%TYPE := 0;
9228: l_mtli_primary_quantity NUMBER := 0;
9229: l_current_grp_prim_qty NUMBER := 0;
9230: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
9231:

Line 9246: FROM rcv_lots_supply rlsu,

9242:
9243: BEGIN
9244: SELECT NVL(SUM(rlsu.primary_quantity),0)
9245: INTO l_rlsu_primary_quantity
9246: FROM rcv_lots_supply rlsu,
9247: rcv_shipment_lines rsl
9248: WHERE rlsu.shipment_line_id = rsl.shipment_line_id
9249: AND rsl.item_id = p_inventory_item_id
9250: AND rsl.to_organization_id = p_rcv_org_id

Line 9342: l_rlsu_primary_quantity RCV_LOTS_SUPPLY.PRIMARY_QUANTITY%TYPE := 0;

9338: , p_product_txn_id IN NUMBER
9339: , p_from_lpn_id IN NUMBER
9340: , x_return_status OUT NOCOPY VARCHAR2
9341: ) IS
9342: l_rlsu_primary_quantity RCV_LOTS_SUPPLY.PRIMARY_QUANTITY%TYPE := 0;
9343: l_mtli_primary_quantity NUMBER := 0;
9344: l_current_grp_prim_qty NUMBER := 0;
9345: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
9346:

Line 9362: FROM rcv_lots_supply rlsu,

9358:
9359: BEGIN
9360: SELECT NVL(SUM(rlsu.primary_quantity),0)
9361: INTO l_rlsu_primary_quantity
9362: FROM rcv_lots_supply rlsu,
9363: rcv_shipment_lines rsl
9364: WHERE rlsu.shipment_line_id = rsl.shipment_line_id
9365: AND rsl.item_id = p_inventory_item_id
9366: AND rsl.to_organization_id = p_rcv_org_id