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.WMS_CARTNZN_PUB dependencies on MTL_SECONDARY_INVENTORIES

Line 441: FROM mtl_secondary_inventories msi

437: AND wdd.delivery_detail_id = wda.delivery_Detail_id
438: AND nvl(wda.delivery_id,-1) = decode(p_input_for_bulk.delivery_id,null,nvl(wda.delivery_id,-1),p_input_for_bulk.delivery_id)
439: )
440: AND ( EXISTS (SELECT 1 -- sub is bulk picking enabled
441: FROM mtl_secondary_inventories msi
442: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
443: AND msi.organization_id = mmtt.organization_id
444: AND msi.enable_bulk_pick = 'Y')
445: OR EXISTS (SELECT 1 -- item is bulk picking enabled

Line 513: FROM mtl_secondary_inventories msi

509: AND wdd.delivery_detail_id = wda.delivery_Detail_id
510: AND nvl(wda.delivery_id,-1) = decode(p_input_for_bulk.delivery_id,null,nvl(wda.delivery_id,-1),p_input_for_bulk.delivery_id)
511: )
512: AND ( EXISTS (SELECT 1 -- sub is bulk picking enabled
513: FROM mtl_secondary_inventories msi
514: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
515: AND msi.organization_id = mmtt.organization_id
516: AND msi.enable_bulk_pick = 'Y')
517: OR EXISTS (SELECT 1 -- item is bulk picking enabled

Line 597: FROM mtl_secondary_inventories msi

593: AND wdd.delivery_detail_id = wda.delivery_Detail_id
594: AND nvl(wda.delivery_id,-1) = decode(p_input_for_bulk.delivery_id,null,nvl(wda.delivery_id,-1),p_input_for_bulk.delivery_id)
595: )
596: AND ( EXISTS (SELECT 1 -- sub is bulk picking enabled
597: FROM mtl_secondary_inventories msi
598: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
599: AND msi.organization_id = mmtt.organization_id
600: AND msi.enable_bulk_pick = 'Y')
601: OR EXISTS (SELECT 1 -- item is bulk picking enabled

Line 3274: mtl_secondary_inventories sub,

3270:
3271: CURSOR wct_rows IS
3272: SELECT wct.* FROM wms_cartonization_temp wct,
3273: mtl_txn_request_lines mtrl,
3274: mtl_secondary_inventories sub,
3275: mtl_parameters mtlp
3276: WHERE
3277: wct.move_order_line_id =mtrl.line_id
3278: AND mtrl.header_id = p_move_order_header_id

Line 6005: mtl_secondary_inventories sub,

6001:
6002: CURSOR wct_rows IS
6003: SELECT wct.* FROM wms_cartonization_temp wct,
6004: mtl_txn_request_lines mtrl,
6005: mtl_secondary_inventories sub,
6006: mtl_parameters mtlp
6007: WHERE
6008: wct.move_order_line_id =mtrl.line_id
6009: AND mtrl.header_id = p_move_order_header_id

Line 6027: mtl_secondary_inventories sub,

6023:
6024: CURSOR wct_sub_rows IS
6025: SELECT wct.* FROM wms_cartonization_temp wct,
6026: mtl_txn_request_lines mtrl,
6027: mtl_secondary_inventories sub,
6028: mtl_parameters mtlp
6029: WHERE
6030: wct.move_order_line_id =mtrl.line_id
6031: AND mtrl.header_id = p_move_order_header_id

Line 6782: mtl_secondary_inventories sub,

6778:
6779: CURSOR wct_rows IS
6780: SELECT wct.* FROM wms_cartonization_temp wct,
6781: mtl_txn_request_lines mtrl,
6782: mtl_secondary_inventories sub,
6783: mtl_parameters mtlp
6784: WHERE
6785: wct.move_order_line_id =mtrl.line_id
6786: AND mtrl.header_id = p_move_order_header_id

Line 7338: mtl_secondary_inventories sub,

7334:
7335: CURSOR wct_rows IS
7336: SELECT wct.* FROM wms_cartonization_temp wct,
7337: mtl_txn_request_lines mtrl,
7338: mtl_secondary_inventories sub,
7339: mtl_parameters mtlp
7340: WHERE
7341: wct.move_order_line_id =mtrl.line_id
7342: AND mtrl.header_id = p_move_order_header_id

Line 7768: mtl_secondary_inventories sub

7764: SELECT DISTINCT wct.pick_slip_number
7765: FROM wms_cartonization_temp wct,
7766: mtl_txn_request_lines mtrl,
7767: mtl_parameters mtlp,
7768: mtl_secondary_inventories sub
7769: WHERE mtrl.header_id = p_move_order_header_id
7770: AND mtrl.organization_id = p_org_id
7771: AND wct.move_order_line_id = mtrl.line_id
7772: AND wct.organization_id = mtrl.organization_id

Line 7790: mtl_secondary_inventories sub

7786: SELECT DISTINCT wct.pick_slip_number
7787: FROM wms_cartonization_temp wct,
7788: mtl_txn_request_lines mtrl,
7789: mtl_parameters mtlp,
7790: mtl_secondary_inventories sub
7791: WHERE mtrl.header_id = p_move_order_header_id
7792: AND mtrl.organization_id = p_org_id
7793: AND wct.move_order_line_id = mtrl.line_id
7794: AND wct.organization_id = mtrl.organization_id

Line 8194: mtl_secondary_inventories sub,

8190:
8191: SELECT wct.* BULK COLLECT INTO l_mmtt_table
8192: FROM wms_cartonization_temp wct,
8193: mtl_txn_request_lines mtrl,
8194: mtl_secondary_inventories sub,
8195: mtl_parameters mtlp
8196: WHERE wct.move_order_line_id =mtrl.line_id
8197: AND mtrl.header_id = p_move_order_header_id
8198: AND mtlp.organization_id = wct.organization_id

Line 8218: mtl_secondary_inventories sub,

8214:
8215: SELECT wct.* BULK COLLECT INTO l_mmtt_table
8216: FROM wms_cartonization_temp wct,
8217: mtl_txn_request_lines mtrl,
8218: mtl_secondary_inventories sub,
8219: mtl_parameters mtlp
8220: WHERE wct.move_order_line_id =mtrl.line_id
8221: AND mtrl.header_id = p_move_order_header_id
8222: AND mtlp.organization_id = wct.organization_id