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_TRANSFER_APIS dependencies on RCV_LOTS_SUPPLY

Line 780: * b) Validate Lot from rcv_lots_supply for the parent txn

776: /*----------------------------------------------------------------------------*
777: * PROCEDURE: get_avail_quantity_to_transfer
778: * Description: This procedure does the following
779: * a) Validate LPN from rcv_supply for the parent txn
780: * b) Validate Lot from rcv_lots_supply for the parent txn
781: * c) Check the available quantity for the parent transaction
782: * d) Convert the quantity into UOM of MO Line and primary UOM
783: *
784: * Output Parameters:

Line 879: --Validate the lot number against RCV_LOTS_SUPPLY

875: IF (l_debug = 1) THEN
876: print_debug('Validating Lot in parent txn', 4);
877: END IF;
878:
879: --Validate the lot number against RCV_LOTS_SUPPLY
880: IF (p_lot_number IS NOT NULL) THEN
881: BEGIN
882: SELECT count(1)
883: INTO l_lot_count

Line 884: FROM rcv_lots_supply rls

880: IF (p_lot_number IS NOT NULL) THEN
881: BEGIN
882: SELECT count(1)
883: INTO l_lot_count
884: FROM rcv_lots_supply rls
885: WHERE rls.lot_num = p_lot_number
886: AND rls.transaction_id = p_parent_txn_id;
887:
888: IF l_lot_count = 0 THEN

Line 3011: rcv_lots_supply rls,

3007: ,rsl.asn_line_flag asn_line_flag
3008: FROM rcv_supply rs,
3009: rcv_transactions rt,
3010: rcv_shipment_lines rsl,
3011: rcv_lots_supply rls,
3012: rcv_shipment_headers rsh
3013: WHERE rs.item_id = p_item_id
3014: AND Nvl(rs.item_revision,nvl(p_revision,'@@@@')) = nvl(p_revision,'@@@@')
3015: AND rs.to_organization_id = p_organization_id