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.WMS_RETURN_SV dependencies on WMS_LPN_CONTENTS

Line 1131: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlpnc, rcv_transactions rt

1127: , wlpnc.COST_GROUP_ID cg_id
1128: , rt.destination_type_code
1129: , rt.quantity rt_quantity
1130: , rt.parent_transaction_id
1131: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlpnc, rcv_transactions rt
1132: WHERE rt.group_id = p_group_id
1133: AND (((( rt.transaction_type = 'RETURN TO VENDOR'
1134: AND rt.lpn_id IS NOT NULL -- 3603808
1135: )

Line 1165: FROM mtl_serial_numbers msn, wms_lpn_contents wlpnc, rcv_transactions rt

1161: msn.inventory_item_id, msn.revision, msn.lot_number,
1162: msn.serial_number, to_number(null) quantity, wlpnc.uom_code uom_code, rt.transaction_type,
1163: rt.interface_transaction_id, msn.COST_GROUP_ID cg_id,
1164: rt.destination_type_code, rt.quantity rt_quantity, rt.parent_transaction_id
1165: FROM mtl_serial_numbers msn, wms_lpn_contents wlpnc, rcv_transactions rt
1166: WHERE msn.last_txn_source_name = rt.transaction_type
1167: AND msn.last_txn_source_id = rt.interface_transaction_id
1168: AND rt.group_id = p_group_id
1169: AND (((( rt.transaction_type = 'RETURN TO VENDOR' -- 3603808

Line 1213: FROM wms_lpn_contents wlpnc, rcv_transactions_interface rti, rcv_transactions rt

1209: , rti.interface_transaction_id
1210: , rti.destination_type_code
1211: , rti.quantity rti_quantity
1212: , rti.parent_transaction_id
1213: FROM wms_lpn_contents wlpnc, rcv_transactions_interface rti, rcv_transactions rt
1214: WHERE rti.group_id = p_group_id
1215: AND rti.transaction_type = 'CORRECT'
1216: AND rt.transaction_id = rti.parent_transaction_id
1217: AND ((rt.transaction_type in ('RETURN TO VENDOR','RETURN TO CUSTOMER') AND rti.quantity < 0) OR

Line 1237: FROM mtl_serial_numbers msn, wms_lpn_contents wlpnc, rcv_transactions_interface rti, rcv_transactions rt

1233: , rti.interface_transaction_id
1234: , rti.destination_type_code
1235: , rti.quantity rti_quantity
1236: , rti.parent_transaction_id
1237: FROM mtl_serial_numbers msn, wms_lpn_contents wlpnc, rcv_transactions_interface rti, rcv_transactions rt
1238: WHERE msn.last_txn_source_name = rti.transaction_type
1239: AND msn.last_txn_source_id = rti.interface_transaction_id
1240: AND rti.group_id = p_group_id
1241: AND rti.transaction_type = 'CORRECT'

Line 2160: UPDATE wms_lpn_contents

2156: */
2157:
2158: FOR i IN c_failure LOOP
2159:
2160: UPDATE wms_lpn_contents
2161: SET source_name = NULL
2162: WHERE source_name = i.transaction_type
2163: AND source_header_id = i.interface_transaction_id;
2164:

Line 2240: FROM wms_lpn_contents

2236:
2237: BEGIN
2238:
2239: SELECT '1' INTO v_dummy
2240: FROM wms_lpn_contents
2241: WHERE nvl(serial_summary_entry,2) <> 1
2242: AND parent_lpn_id = p_lpn_id
2243: AND organization_id = p_org_id
2244: AND nvl(source_name,'@@@') IN ('RETURN TO VENDOR', 'RETURN TO RECEIVING', 'RETURN TO CUSTOMER')

Line 2282: FROM wms_lpn_contents

2278:
2279: BEGIN
2280:
2281: SELECT '1' INTO v_dummy
2282: FROM wms_lpn_contents
2283: WHERE nvl(serial_summary_entry,2) <> 1
2284: AND parent_lpn_id = p_lpn_id
2285: AND ORGANIZATION_ID = p_org_id
2286: AND nvl(source_name,'@@@') NOT IN ('RETURN TO VENDOR', 'RETURN TO RECEIVING', 'RETURN TO CUSTOMER')

Line 2410: ** than one record in wms_lpn_contents, but we need

2406: /* Lot Controlled */
2407: l_position := '0030';
2408:
2409: /* For a given LPN, Lot and Item combination there could be more
2410: ** than one record in wms_lpn_contents, but we need
2411: ** only one record per LPN, Lot and Item combination as an output of this cursor
2412: */
2413:
2414: open c_ref for SELECT DISTINCT MTLT.LOT_NUMBER, NULL FM_SERIAL_NUMBER,

Line 2416: FROM WMS_LPN_CONTENTS WLPNC, MTL_TRANSACTION_LOTS_TEMP MTLT

2412: */
2413:
2414: open c_ref for SELECT DISTINCT MTLT.LOT_NUMBER, NULL FM_SERIAL_NUMBER,
2415: NULL TO_SERIAL_NUMBER, MTLT.transaction_quantity quantity,wlpnc.cost_group_id
2416: FROM WMS_LPN_CONTENTS WLPNC, MTL_TRANSACTION_LOTS_TEMP MTLT
2417: WHERE MTLT.TRANSACTION_TEMP_ID = p_rcv_trx_interface_id
2418: AND WLPNC.LOT_NUMBER = MTLT.LOT_NUMBER
2419: AND WLPNC.PARENT_LPN_ID = p_lpn_id
2420: AND WLPNC.INVENTORY_ITEM_ID = P_ITEM_ID

Line 2431: wms_lpn_contents wlpnc

2427: l_position := '0040';
2428: open c_ref for SELECT NULL LOT_NUMBER, MSN.SERIAL_NUMBER FM_SERIAL_NUMBER,
2429: MSN.SERIAL_NUMBER TO_SERIAL_NUMBER, null quantity, msn.COST_GROUP_ID
2430: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_TEMP msnt,
2431: wms_lpn_contents wlpnc
2432: WHERE MSNT.TRANSACTION_TEMP_ID = p_rcv_trx_interface_id
2433: AND MSN.INVENTORY_ITEM_ID = p_item_id
2434: AND Nvl(MSN.revision,'@@@') = Nvl(p_item_revision,'@@@')
2435: AND MSN.SERIAL_NUMBER >= MSNT.FM_SERIAL_NUMBER

Line 2448: FROM WMS_LPN_CONTENTS WLPNC, RCV_TRANSACTIONS_INTERFACE RTI

2444: ELSE
2445:
2446: l_position := '0050';
2447: open c_ref for SELECT NULL , NULL , NULL , rti.quantity, wlpnc.cost_group_id
2448: FROM WMS_LPN_CONTENTS WLPNC, RCV_TRANSACTIONS_INTERFACE RTI
2449: WHERE RTI.INTERFACE_TRANSACTION_ID = p_rcv_trx_interface_id
2450: AND WLPNC.PARENT_LPN_ID = p_lpn_id
2451: AND WLPNC.INVENTORY_ITEM_ID = RTI.ITEM_ID
2452: AND nvl(WLPNC.SOURCE_NAME,'@@@') not in ('RETURN TO RECEIVING','RETURN TO VENDOR', 'RETURN TO CUSTOMER')

Line 2456: ** than one record in wms_lpn_contents, but we need

2452: AND nvl(WLPNC.SOURCE_NAME,'@@@') not in ('RETURN TO RECEIVING','RETURN TO VENDOR', 'RETURN TO CUSTOMER')
2453: AND rownum <= 1;
2454:
2455: /* For a given LPN and Item combination there could be more
2456: ** than one record in wms_lpn_contents, but we need
2457: ** only one record as an output of this cursor
2458: */
2459: l_uom := p_uom;
2460: END IF;

Line 2822: FROM WMS_LPN_CONTENTS WLPNC

2818:
2819: x_return_status := fnd_api.g_ret_sts_success;
2820:
2821: open c_ref for SELECT SOURCE_HEADER_ID
2822: FROM WMS_LPN_CONTENTS WLPNC
2823: WHERE WLPNC.ORGANIZATION_ID = p_org_id
2824: AND WLPNC.PARENT_LPN_ID = p_lpn_id
2825: AND NVL(SERIAL_SUMMARY_ENTRY,2) <> 1 -- Non Serial Contents Records(value=2)
2826: AND WLPNC.SOURCE_NAME IN ('RETURN TO VENDOR',

Line 3005: FROM WMS_LPN_CONTENTS WLPNC

3001: END IF;
3002:
3003: IF p_lot_controlled = 2 AND p_serial_controlled = 2 THEN -- NonSerial and NonLot
3004: open c_ref for SELECT SOURCE_HEADER_ID
3005: FROM WMS_LPN_CONTENTS WLPNC
3006: WHERE WLPNC.ORGANIZATION_ID = p_org_id
3007: AND WLPNC.PARENT_LPN_ID = p_lpn_id
3008: AND WLPNC.INVENTORY_ITEM_ID = p_item_id
3009: AND ((WLPNC.revision = p_item_revision AND p_item_revision IS NOT NULL) OR

Line 3029: FROM WMS_LPN_CONTENTS WLPNC

3025: AND MSN.SERIAL_NUMBER = p_serial_code;
3026:
3027: ELSIF p_lot_controlled = 1 AND p_serial_controlled = 2 THEN -- Lot Only
3028: open c_ref for SELECT SOURCE_HEADER_ID
3029: FROM WMS_LPN_CONTENTS WLPNC
3030: WHERE WLPNC.ORGANIZATION_ID = p_org_id
3031: AND WLPNC.PARENT_LPN_ID = p_lpn_id
3032: AND WLPNC.INVENTORY_ITEM_ID = p_item_id
3033: AND ((WLPNC.REVISION = p_item_revision AND p_item_revision IS NOT NULL) OR

Line 3326: --FROM wms_lpn_contents wlc,

3322:
3323: -- BEGIN
3324: -- SELECT wlc.lot_number
3325: -- INTO l_lot_number
3326: --FROM wms_lpn_contents wlc,
3327: -- mtl_system_items msi
3328: --WHERE wlc.parent_lpn_id = p_lpn_id
3329: --AND wlc.organization_id = p_org_id
3330: --AND wlc.inventory_item_id = p_item_id