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_LABEL_PVT4 dependencies on WMS_CARTNZN_WRAP

Line 758: --AND milkfv.subinventory_code(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,

754: connect by parent_lpn_id = prior lpn_id)
755: AND plpn.lpn_id (+) = wlc.parent_lpn_id
756: AND milkfv.organization_id (+) = NVL(p_organization_id, plpn.organization_id)
757: -- Bug 4137707
758: --AND milkfv.subinventory_code(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
759: -- nvl(l_subinventory_code, plpn.subinventory_code))
760: --AND milkfv.inventory_location_id(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
761: -- nvl(l_locator_id, plpn.locator_id))
762: AND milkfv.subinventory_code(+) = nvl(l_subinventory_code, plpn.subinventory_code)

Line 760: --AND milkfv.inventory_location_id(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,

756: AND milkfv.organization_id (+) = NVL(p_organization_id, plpn.organization_id)
757: -- Bug 4137707
758: --AND milkfv.subinventory_code(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
759: -- nvl(l_subinventory_code, plpn.subinventory_code))
760: --AND milkfv.inventory_location_id(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
761: -- nvl(l_locator_id, plpn.locator_id))
762: AND milkfv.subinventory_code(+) = nvl(l_subinventory_code, plpn.subinventory_code)
763: AND milkfv.inventory_location_id(+) = nvl(l_locator_id, plpn.locator_id)
764: AND ccg.cost_group_id (+) = nvl(p_cost_group_id, wlc.cost_group_id)

Line 808: --AND milkfv.subinventory_code(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,

804: WHERE plpn.lpn_id (+) = p_lpn_id
805: AND p_label_type_info.business_flow_code NOT IN (19) /* Modified for bug# 5168330*/
806: AND milkfv.organization_id (+) = NVL(p_organization_id, plpn.organization_id)
807: -- Bug 4137707
808: --AND milkfv.subinventory_code(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
809: -- nvl(l_subinventory_code, plpn.subinventory_code))
810: --AND milkfv.inventory_location_id(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
811: -- nvl(l_locator_id, plpn.locator_id))
812: AND milkfv.subinventory_code(+) = nvl(l_subinventory_code, plpn.subinventory_code)

Line 810: --AND milkfv.inventory_location_id(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,

806: AND milkfv.organization_id (+) = NVL(p_organization_id, plpn.organization_id)
807: -- Bug 4137707
808: --AND milkfv.subinventory_code(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
809: -- nvl(l_subinventory_code, plpn.subinventory_code))
810: --AND milkfv.inventory_location_id(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
811: -- nvl(l_locator_id, plpn.locator_id))
812: AND milkfv.subinventory_code(+) = nvl(l_subinventory_code, plpn.subinventory_code)
813: AND milkfv.inventory_location_id(+) = nvl(l_locator_id, plpn.locator_id)
814: AND ccg.cost_group_id (+) = nvl(p_cost_group_id, mmtt.cost_group_id)

Line 879: AND milkfv.subinventory_code(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,

875: AND mmtt.transaction_temp_id (+) = wpc.reference_id
876: AND msi.inventory_item_id (+) = mmtt.inventory_item_id
877: AND msi.organization_id (+) = mmtt.organization_id
878: AND milkfv.organization_id (+) = mmtt.organization_id
879: AND milkfv.subinventory_code(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
880: mmtt.subinventory_code)
881: AND milkfv.inventory_location_id(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
882: mmtt.locator_id)
883: AND ccg.cost_group_id (+) = mmtt.cost_group_id

Line 881: AND milkfv.inventory_location_id(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,

877: AND msi.organization_id (+) = mmtt.organization_id
878: AND milkfv.organization_id (+) = mmtt.organization_id
879: AND milkfv.subinventory_code(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
880: mmtt.subinventory_code)
881: AND milkfv.inventory_location_id(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
882: mmtt.locator_id)
883: AND ccg.cost_group_id (+) = mmtt.cost_group_id
884: GROUP BY
885: wpc.organization_id