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 1078: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074.

1074: start with lpn_id = p_lpn_id
1075: connect by parent_lpn_id = prior lpn_id)
1076: AND wlc.parent_lpn_id(+) = plpn.lpn_id
1077: AND milkfv.organization_id (+) = NVL(p_organization_id, plpn.organization_id)
1078: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074.
1079: -- Bug 4137707
1080: --AND milkfv.subinventory_code(+) =
1081: -- DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1082: -- nvl(l_subinventory_code,plpn.subinventory_code))

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

1077: AND milkfv.organization_id (+) = NVL(p_organization_id, plpn.organization_id)
1078: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074.
1079: -- Bug 4137707
1080: --AND milkfv.subinventory_code(+) =
1081: -- DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1082: -- nvl(l_subinventory_code,plpn.subinventory_code))
1083: --AND milkfv.inventory_location_id(+) =
1084: -- DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1085: -- nvl(l_locator_id, plpn.locator_id))

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

1080: --AND milkfv.subinventory_code(+) =
1081: -- DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1082: -- nvl(l_subinventory_code,plpn.subinventory_code))
1083: --AND milkfv.inventory_location_id(+) =
1084: -- DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1085: -- nvl(l_locator_id, plpn.locator_id))
1086: AND milkfv.subinventory_code(+) = nvl(l_subinventory_code,plpn.subinventory_code)
1087: AND milkfv.inventory_location_id(+) = nvl(l_locator_id, plpn.locator_id)
1088: AND ccg.cost_group_id (+) = nvl(p_cost_group_id, wlc.cost_group_id)

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

1193: connect by PARENT_PACKAGE_ID = PRIOR PACKAGE_ID)
1194: connect by parent_lpn_id = prior lpn_id) ) t )
1195: AND wlc.parent_lpn_id(+) = plpn.lpn_id
1196: AND milkfv.organization_id (+) = plpn.organization_id
1197: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074.
1198: AND milkfv.subinventory_code(+) =
1199: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1200: plpn.subinventory_code)
1201: AND milkfv.inventory_location_id(+) =

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

1195: AND wlc.parent_lpn_id(+) = plpn.lpn_id
1196: AND milkfv.organization_id (+) = plpn.organization_id
1197: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074.
1198: AND milkfv.subinventory_code(+) =
1199: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1200: plpn.subinventory_code)
1201: AND milkfv.inventory_location_id(+) =
1202: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1203: plpn.locator_id)

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

1198: AND milkfv.subinventory_code(+) =
1199: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1200: plpn.subinventory_code)
1201: AND milkfv.inventory_location_id(+) =
1202: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1203: plpn.locator_id)
1204: AND ccg.cost_group_id (+) = wlc.cost_group_id
1205: -- Added the AND for fix to Bug 2764074..
1206: -- Bug 4137707

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

1256: -- WHERE cartonization_flag = 1 --Cartonization Flow
1257: WHERE wpc.rowid in ( select /*+ cardinality(1) */ id from ((select rowid id from wms_packaging_hist
1258: where pack_level = 0
1259: AND header_id = l_header_id
1260: AND l_packaging_mode in (WMS_CARTNZN_WRAP.PR_PKG_MODE, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode)
1261: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074..
1262: AND lpn_id is null
1263: start with parent_lpn_id = p_lpn_id
1264: connect by PARENT_PACKAGE_ID = PRIOR PACKAGE_ID

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

1257: WHERE wpc.rowid in ( select /*+ cardinality(1) */ id from ((select rowid id from wms_packaging_hist
1258: where pack_level = 0
1259: AND header_id = l_header_id
1260: AND l_packaging_mode in (WMS_CARTNZN_WRAP.PR_PKG_MODE, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode)
1261: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074..
1262: AND lpn_id is null
1263: start with parent_lpn_id = p_lpn_id
1264: connect by PARENT_PACKAGE_ID = PRIOR PACKAGE_ID
1265: union all

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

1271: AND mmtt.transaction_temp_id (+) = wpc.reference_id
1272: AND msi.inventory_item_id (+) = wpc.inventory_item_id
1273: AND msi.organization_id (+) = wpc.organization_id
1274: AND milkfv.organization_id (+) = mmtt.organization_id
1275: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074..
1276: AND milkfv.subinventory_code(+) =
1277: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1278: mmtt.subinventory_code)
1279: AND milkfv.inventory_location_id(+) =

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

1273: AND msi.organization_id (+) = wpc.organization_id
1274: AND milkfv.organization_id (+) = mmtt.organization_id
1275: -- Added the new mode (WMS_CARTNZN_WRAP.mfg_pr_pkg_mode) for fix to Bug 2764074..
1276: AND milkfv.subinventory_code(+) =
1277: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1278: mmtt.subinventory_code)
1279: AND milkfv.inventory_location_id(+) =
1280: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1281: mmtt.locator_id)

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

1276: AND milkfv.subinventory_code(+) =
1277: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1278: mmtt.subinventory_code)
1279: AND milkfv.inventory_location_id(+) =
1280: DECODE(l_packaging_mode, WMS_CARTNZN_WRAP.PR_PKG_MODE, NULL, WMS_CARTNZN_WRAP.mfg_pr_pkg_mode, NULL,
1281: mmtt.locator_id)
1282: AND ccg.cost_group_id (+) = mmtt.cost_group_id
1283: GROUP BY
1284: wpc.organization_id