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 927: --AND milkfv.subinventory_code(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,

923: connect by parent_lpn_id = prior lpn_id) Commented for the bug # 14493747 */
924: AND plpn.lpn_id (+) = wlc.parent_lpn_id
925: AND milkfv.organization_id (+) = NVL(p_organization_id, plpn.organization_id)
926: -- Bug 4137707
927: --AND milkfv.subinventory_code(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
928: -- nvl(l_subinventory_code, plpn.subinventory_code))
929: --AND milkfv.inventory_location_id(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
930: -- nvl(l_locator_id, plpn.locator_id))
931: AND milkfv.subinventory_code(+) = nvl(l_subinventory_code, plpn.subinventory_code)

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

925: AND milkfv.organization_id (+) = NVL(p_organization_id, plpn.organization_id)
926: -- Bug 4137707
927: --AND milkfv.subinventory_code(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
928: -- nvl(l_subinventory_code, plpn.subinventory_code))
929: --AND milkfv.inventory_location_id(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
930: -- nvl(l_locator_id, plpn.locator_id))
931: AND milkfv.subinventory_code(+) = nvl(l_subinventory_code, plpn.subinventory_code)
932: AND milkfv.inventory_location_id(+) = nvl(l_locator_id, plpn.locator_id)
933: AND ccg.cost_group_id (+) = nvl(p_cost_group_id, wlc.cost_group_id)

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

973: WHERE plpn.lpn_id (+) = p_lpn_id
974: AND p_label_type_info.business_flow_code NOT IN (19,20) /* Modified for bug# 5168330*/
975: AND milkfv.organization_id (+) = NVL(p_organization_id, plpn.organization_id)
976: -- Bug 4137707
977: --AND milkfv.subinventory_code(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
978: -- nvl(l_subinventory_code, plpn.subinventory_code))
979: --AND milkfv.inventory_location_id(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
980: -- nvl(l_locator_id, plpn.locator_id))
981: AND milkfv.subinventory_code(+) = nvl(l_subinventory_code, plpn.subinventory_code)

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

975: AND milkfv.organization_id (+) = NVL(p_organization_id, plpn.organization_id)
976: -- Bug 4137707
977: --AND milkfv.subinventory_code(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
978: -- nvl(l_subinventory_code, plpn.subinventory_code))
979: --AND milkfv.inventory_location_id(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
980: -- nvl(l_locator_id, plpn.locator_id))
981: AND milkfv.subinventory_code(+) = nvl(l_subinventory_code, plpn.subinventory_code)
982: AND milkfv.inventory_location_id(+) = nvl(l_locator_id, plpn.locator_id)
983: AND ccg.cost_group_id (+) = nvl(p_cost_group_id, mmtt.cost_group_id)

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

1049: AND mmtt.transaction_temp_id (+) = wpc.reference_id
1050: AND msi.inventory_item_id (+) = NVL(p_item_id, mmtt.inventory_item_id) -- 8816529
1051: AND msi.organization_id (+) = NVL(p_organization_id, mmtt.organization_id) -- 8816529
1052: AND milkfv.organization_id (+) = mmtt.organization_id
1053: AND milkfv.subinventory_code(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
1054: mmtt.subinventory_code)
1055: AND milkfv.inventory_location_id(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
1056: mmtt.locator_id)
1057: AND ccg.cost_group_id (+) = mmtt.cost_group_id

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

1051: AND msi.organization_id (+) = NVL(p_organization_id, mmtt.organization_id) -- 8816529
1052: AND milkfv.organization_id (+) = mmtt.organization_id
1053: AND milkfv.subinventory_code(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
1054: mmtt.subinventory_code)
1055: AND milkfv.inventory_location_id(+) = DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL,
1056: mmtt.locator_id)
1057: AND ccg.cost_group_id (+) = mmtt.cost_group_id
1058: GROUP BY
1059: wpc.organization_id