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 722: FROM mtl_secondary_inventories

718: AND(p_mmtt.transaction_action_id <> inv_globals.g_action_intransitreceipt)
719: AND(NVL(p_mmtt.transfer_subinventory, p_mmtt.subinventory_code) IS NOT NULL) THEN
720: SELECT NVL(lpn_controlled_flag, 2)
721: INTO l_skip_comingle_check
722: FROM mtl_secondary_inventories
723: WHERE organization_id = NVL(p_mmtt.transfer_organization, p_mmtt.organization_id)
724: AND secondary_inventory_name = NVL(p_mmtt.transfer_subinventory, p_mmtt.subinventory_code);
725:
726: IF SQL%NOTFOUND THEN

Line 5763: FROM mtl_secondary_inventories

5759: -- If receiving a complete LPN, then check for the autoUnpack
5760: -- status of the subinventory to which it is received
5761: SELECT lpn_controlled_flag
5762: INTO v_autounpack
5763: FROM mtl_secondary_inventories
5764: WHERE organization_id = p_organization_id
5765: AND secondary_inventory_name = p_subinventory_code;
5766:
5767: v_lpn.lpn_id := p_content_lpn_id;

Line 5961: FROM mtl_secondary_inventories

5957: ) THEN
5958: -- Get the LPN_CONTROLLED_FLAG status of the transfer subinventory
5959: SELECT lpn_controlled_flag
5960: INTO v_autounpack
5961: FROM mtl_secondary_inventories
5962: WHERE organization_id = v_xfr_org
5963: AND secondary_inventory_name = p_transfer_subinventory;
5964:
5965: IF (l_debug = 1) THEN