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_LPN_TRX_PUB dependencies on MTL_SECONDARY_INVENTORIES

Line 918: FROM mtl_secondary_inventories

914: AND(p_mmtt.transaction_action_id <> inv_globals.g_action_intransitreceipt)
915: AND(NVL(p_mmtt.transfer_subinventory, p_mmtt.subinventory_code) IS NOT NULL) THEN
916: SELECT NVL(lpn_controlled_flag, 2)
917: INTO l_skip_comingle_check
918: FROM mtl_secondary_inventories
919: WHERE organization_id = NVL(p_mmtt.transfer_organization, p_mmtt.organization_id)
920: AND secondary_inventory_name = NVL(p_mmtt.transfer_subinventory, p_mmtt.subinventory_code);
921:
922: IF SQL%NOTFOUND THEN

Line 6502: FROM mtl_secondary_inventories

6498: -- If receiving a complete LPN, then check for the autoUnpack
6499: -- status of the subinventory to which it is received
6500: SELECT lpn_controlled_flag
6501: INTO v_autounpack
6502: FROM mtl_secondary_inventories
6503: WHERE organization_id = p_organization_id
6504: AND secondary_inventory_name = p_subinventory_code;
6505:
6506: v_lpn.lpn_id := p_content_lpn_id;

Line 6725: FROM mtl_secondary_inventories

6721: ) THEN
6722: -- Get the LPN_CONTROLLED_FLAG status of the transfer subinventory
6723: SELECT lpn_controlled_flag
6724: INTO v_autounpack
6725: FROM mtl_secondary_inventories
6726: WHERE organization_id = v_xfr_org
6727: AND secondary_inventory_name = p_transfer_subinventory;
6728:
6729: IF (l_debug = 1) THEN