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 540: FROM mtl_secondary_inventories msi

536: AND wdd.delivery_detail_id = wda.delivery_Detail_id
537: 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)
538: )
539: AND ( EXISTS (SELECT 1 -- sub is bulk picking enabled
540: FROM mtl_secondary_inventories msi
541: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
542: AND msi.organization_id = mmtt.organization_id
543: AND msi.enable_bulk_pick = 'Y')
544: OR EXISTS (SELECT 1 -- item is bulk picking enabled

Line 610: FROM mtl_secondary_inventories msi

606: AND wdd.delivery_detail_id = wda.delivery_Detail_id
607: 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)
608: )
609: AND ( EXISTS (SELECT 1 -- sub is bulk picking enabled
610: FROM mtl_secondary_inventories msi
611: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
612: AND msi.organization_id = mmtt.organization_id
613: AND msi.enable_bulk_pick = 'Y')
614: OR EXISTS (SELECT 1 -- item is bulk picking enabled

Line 692: FROM mtl_secondary_inventories msi

688: AND wdd.delivery_detail_id = wda.delivery_Detail_id
689: 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)
690: )
691: AND ( EXISTS (SELECT 1 -- sub is bulk picking enabled
692: FROM mtl_secondary_inventories msi
693: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
694: AND msi.organization_id = mmtt.organization_id
695: AND msi.enable_bulk_pick = 'Y')
696: OR EXISTS (SELECT 1 -- item is bulk picking enabled

Line 3294: mtl_secondary_inventories sub,

3290:
3291: CURSOR wct_rows IS
3292: SELECT wct.* FROM wms_cartonization_temp wct,
3293: mtl_txn_request_lines mtrl,
3294: mtl_secondary_inventories sub,
3295: mtl_parameters mtlp
3296: WHERE
3297: wct.move_order_line_id =mtrl.line_id
3298: AND mtrl.header_id = p_move_order_header_id

Line 5966: mtl_secondary_inventories sub,

5962:
5963: CURSOR wct_rows IS
5964: SELECT wct.* FROM wms_cartonization_temp wct,
5965: mtl_txn_request_lines mtrl,
5966: mtl_secondary_inventories sub,
5967: mtl_parameters mtlp
5968: WHERE
5969: wct.move_order_line_id =mtrl.line_id
5970: AND mtrl.header_id = p_move_order_header_id

Line 5985: mtl_secondary_inventories sub,

5981:
5982: CURSOR wct_sub_rows IS
5983: SELECT wct.* FROM wms_cartonization_temp wct,
5984: mtl_txn_request_lines mtrl,
5985: mtl_secondary_inventories sub,
5986: mtl_parameters mtlp
5987: WHERE
5988: wct.move_order_line_id =mtrl.line_id
5989: AND mtrl.header_id = p_move_order_header_id

Line 6723: mtl_secondary_inventories sub,

6719:
6720: CURSOR wct_rows IS
6721: SELECT wct.* FROM wms_cartonization_temp wct,
6722: mtl_txn_request_lines mtrl,
6723: mtl_secondary_inventories sub,
6724: mtl_parameters mtlp
6725: WHERE
6726: wct.move_order_line_id =mtrl.line_id
6727: AND mtrl.header_id = p_move_order_header_id

Line 7258: mtl_secondary_inventories sub,

7254:
7255: CURSOR wct_rows IS
7256: SELECT wct.* FROM wms_cartonization_temp wct,
7257: mtl_txn_request_lines mtrl,
7258: mtl_secondary_inventories sub,
7259: mtl_parameters mtlp
7260: WHERE
7261: wct.move_order_line_id =mtrl.line_id
7262: AND mtrl.header_id = p_move_order_header_id

Line 7685: mtl_secondary_inventories sub

7681: SELECT DISTINCT wct.pick_slip_number
7682: FROM wms_cartonization_temp wct,
7683: mtl_txn_request_lines mtrl,
7684: mtl_parameters mtlp,
7685: mtl_secondary_inventories sub
7686: WHERE mtrl.header_id = p_move_order_header_id
7687: AND mtrl.organization_id = p_org_id
7688: AND wct.move_order_line_id = mtrl.line_id
7689: AND wct.organization_id = mtrl.organization_id

Line 7704: mtl_secondary_inventories sub

7700: SELECT DISTINCT wct.pick_slip_number
7701: FROM wms_cartonization_temp wct,
7702: mtl_txn_request_lines mtrl,
7703: mtl_parameters mtlp,
7704: mtl_secondary_inventories sub
7705: WHERE mtrl.header_id = p_move_order_header_id
7706: AND mtrl.organization_id = p_org_id
7707: AND wct.move_order_line_id = mtrl.line_id
7708: AND wct.organization_id = mtrl.organization_id

Line 8105: mtl_secondary_inventories sub,

8101:
8102: SELECT wct.* BULK COLLECT INTO l_mmtt_table
8103: FROM wms_cartonization_temp wct,
8104: mtl_txn_request_lines mtrl,
8105: mtl_secondary_inventories sub,
8106: mtl_parameters mtlp
8107: WHERE wct.move_order_line_id =mtrl.line_id
8108: AND mtrl.header_id = p_move_order_header_id
8109: AND mtlp.organization_id = wct.organization_id

Line 8126: mtl_secondary_inventories sub,

8122:
8123: SELECT wct.* BULK COLLECT INTO l_mmtt_table
8124: FROM wms_cartonization_temp wct,
8125: mtl_txn_request_lines mtrl,
8126: mtl_secondary_inventories sub,
8127: mtl_parameters mtlp
8128: WHERE wct.move_order_line_id =mtrl.line_id
8129: AND mtrl.header_id = p_move_order_header_id
8130: AND mtlp.organization_id = wct.organization_id