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

Line 933: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074.

929: start with lpn_id = p_lpn_id
930: connect by parent_lpn_id = prior lpn_id)
931: AND wlc.parent_lpn_id(+) = plpn.lpn_id
932: AND milkfv.organization_id (+) = NVL(p_organization_id, plpn.organization_id)
933: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074.
934: -- Bug 4137707
935: --AND milkfv.subinventory_code(+) =
936: -- DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
937: -- nvl(l_subinventory_code,plpn.subinventory_code))

Line 936: -- DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,

932: AND milkfv.organization_id (+) = NVL(p_organization_id, plpn.organization_id)
933: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074.
934: -- Bug 4137707
935: --AND milkfv.subinventory_code(+) =
936: -- DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
937: -- nvl(l_subinventory_code,plpn.subinventory_code))
938: --AND milkfv.inventory_location_id(+) =
939: -- DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
940: -- nvl(l_locator_id, plpn.locator_id))

Line 939: -- DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,

935: --AND milkfv.subinventory_code(+) =
936: -- DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
937: -- nvl(l_subinventory_code,plpn.subinventory_code))
938: --AND milkfv.inventory_location_id(+) =
939: -- DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
940: -- nvl(l_locator_id, plpn.locator_id))
941: AND milkfv.subinventory_code(+) = nvl(l_subinventory_code,plpn.subinventory_code)
942: AND milkfv.inventory_location_id(+) = nvl(l_locator_id, plpn.locator_id)
943: AND ccg.cost_group_id (+) = nvl(p_cost_group_id, wlc.cost_group_id)

Line 1049: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074.

1045: connect by PARENT_PACKAGE_ID = PRIOR PACKAGE_ID)
1046: connect by parent_lpn_id = prior lpn_id)
1047: AND wlc.parent_lpn_id(+) = plpn.lpn_id
1048: AND milkfv.organization_id (+) = plpn.organization_id
1049: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074.
1050: AND milkfv.subinventory_code(+) =
1051: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1052: plpn.subinventory_code)
1053: AND milkfv.inventory_location_id(+) =

Line 1051: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,

1047: AND wlc.parent_lpn_id(+) = plpn.lpn_id
1048: AND milkfv.organization_id (+) = plpn.organization_id
1049: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074.
1050: AND milkfv.subinventory_code(+) =
1051: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1052: plpn.subinventory_code)
1053: AND milkfv.inventory_location_id(+) =
1054: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1055: plpn.locator_id)

Line 1054: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,

1050: AND milkfv.subinventory_code(+) =
1051: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1052: plpn.subinventory_code)
1053: AND milkfv.inventory_location_id(+) =
1054: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1055: plpn.locator_id)
1056: AND ccg.cost_group_id (+) = wlc.cost_group_id
1057: -- Added the AND for fix to Bug 2764074..
1058: -- Bug 4137707

Line 1112: AND l_packaging_mode in (WMS_CARTNZN_WRAP.PR_PKG_MODE, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode)

1108: -- WHERE cartonization_flag = 1 --Cartonization Flow
1109: WHERE wpc.rowid in (select rowid from wms_packaging_hist
1110: where pack_level = 0
1111: AND header_id = l_header_id
1112: AND l_packaging_mode in (WMS_CARTNZN_WRAP.PR_PKG_MODE, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode)
1113: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074..
1114: AND lpn_id is null
1115: start with parent_lpn_id = p_lpn_id
1116: connect by PARENT_PACKAGE_ID = PRIOR PACKAGE_ID

Line 1113: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074..

1109: WHERE wpc.rowid in (select rowid from wms_packaging_hist
1110: where pack_level = 0
1111: AND header_id = l_header_id
1112: AND l_packaging_mode in (WMS_CARTNZN_WRAP.PR_PKG_MODE, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode)
1113: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074..
1114: AND lpn_id is null
1115: start with parent_lpn_id = p_lpn_id
1116: connect by PARENT_PACKAGE_ID = PRIOR PACKAGE_ID
1117: union all

Line 1127: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074..

1123: AND mmtt.transaction_temp_id (+) = wpc.reference_id
1124: AND msi.inventory_item_id (+) = wpc.inventory_item_id
1125: AND msi.organization_id (+) = wpc.organization_id
1126: AND milkfv.organization_id (+) = mmtt.organization_id
1127: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074..
1128: AND milkfv.subinventory_code(+) =
1129: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1130: mmtt.subinventory_code)
1131: AND milkfv.inventory_location_id(+) =

Line 1129: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,

1125: AND msi.organization_id (+) = wpc.organization_id
1126: AND milkfv.organization_id (+) = mmtt.organization_id
1127: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074..
1128: AND milkfv.subinventory_code(+) =
1129: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1130: mmtt.subinventory_code)
1131: AND milkfv.inventory_location_id(+) =
1132: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1133: mmtt.locator_id)

Line 1132: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,

1128: AND milkfv.subinventory_code(+) =
1129: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1130: mmtt.subinventory_code)
1131: AND milkfv.inventory_location_id(+) =
1132: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1133: mmtt.locator_id)
1134: AND ccg.cost_group_id (+) = mmtt.cost_group_id
1135: GROUP BY
1136: wpc.organization_id