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_TXN_REQUEST_LINES

Line 485: mtl_material_transactions_temp mmtt, mtl_txn_request_lines

481:
482: CURSOR c1(mo_hdr_id NUMBER) IS
483: /* added the index hint with the suggestion of apps performance team */
484: SELECT /*+index (mmtt,mtl_material_trans_temp_n14)*/ mmtt.* FROM
485: mtl_material_transactions_temp mmtt, mtl_txn_request_lines
486: mtrl WHERE mtrl.header_id = mo_hdr_id AND
487: mmtt.move_order_line_id = mtrl.line_id AND
488: --2513907 fix
489: mmtt.container_item_id IS null;

Line 2762: mtl_txn_request_lines mtrl

2758: wct.cartonization_id,
2759: wct.CONTAINER_ITEM_ID
2760: FROM
2761: wms_cartonization_temp wct,
2762: mtl_txn_request_lines mtrl
2763: WHERE
2764: wct.move_order_line_id = mtrl.line_id AND
2765: mtrl.header_id = p_header_id AND
2766: wct.transaction_header_id >= 0 -- AND

Line 3293: mtl_txn_request_lines mtrl,

3289: l_count1 NUMBER;
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

Line 3318: mtl_txn_request_lines mtrl WHERE

3314: SELECT DISTINCT mmtt.cartonization_id FROM
3315: --2513907 fix
3316: wms_cartonization_temp mmtt,
3317: --mtl_material_transactions_temp mmtt,
3318: mtl_txn_request_lines mtrl WHERE
3319: mmtt.move_order_line_id = mtrl.line_id
3320: AND mtrl.header_id = p_move_order_header_id
3321: AND mmtt.cartonization_id IS NOT NULL
3322: ORDER BY mmtt.cartonization_id;

Line 3395: mtl_txn_request_lines mtrl

3391: wct.container_item_id,
3392: wct.cartonization_id
3393: FROM
3394: wms_cartonization_temp wct,
3395: mtl_txn_request_lines mtrl
3396: WHERE
3397: wct.move_order_line_id = mtrl.line_id AND
3398: mtrl.header_id = p_hdr_id
3399: order by wct.cartonization_id;

Line 3717: --mtl_material_transactions_temp mmtt, mtl_txn_request_lines

3713: p_transaction_header_id => NULL,
3714: p_input_for_bulk =>p_input_for_bulk);
3715:
3716: --INSERT INTO wms_cartonization_temp SELECT mmtt.* FROM
3717: --mtl_material_transactions_temp mmtt, mtl_txn_request_lines
3718: --mtrl WHERE mtrl.header_id = p_move_order_header_id AND
3719: --mmtt.move_order_line_id = mtrl.line_id;
3720:
3721: ELSE --outbound = 'N'

Line 5345: SELECT line_id INTO mlid FROM mtl_txn_request_lines WHERE header_id = 40262

5341: x_return_status=> x_return_status,
5342: x_msg_count => x_msg_count,
5343: x_msg_data => x_msg_data );
5344:
5345: SELECT line_id INTO mlid FROM mtl_txn_request_lines WHERE header_id = 40262
5346: AND roWnum < 2;
5347:
5348: wsh_interface.Get_Max_Load_Qty(p_move_order_line_id => mlid,
5349: x_max_load_quantity => v_qty_per_cont,

Line 5633: mtl_txn_request_lines mtrl WHERE wct.move_order_line_id =

5629: x_msg_data OUT NOCOPY VARCHAR2)
5630: is
5631: CURSOR wct_rows IS
5632: SELECT wct.* FROM wms_cartonization_temp wct,
5633: mtl_txn_request_lines mtrl WHERE wct.move_order_line_id =
5634: mtrl.line_id AND mtrl.header_id = p_m_o_h_id;
5635:
5636: -- patchset J bulk picking ---
5637: -- following cursor will be used for calling from concurrent program --

Line 5965: mtl_txn_request_lines mtrl,

5961: l_uom_rate number;
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

Line 5984: mtl_txn_request_lines mtrl,

5980: Abs(wct.transaction_temp_id);
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

Line 6007: mtl_txn_request_lines mtrl WHERE

6003: SELECT DISTINCT mmtt.cartonization_id FROM
6004: --2513907 fix
6005: wms_cartonization_temp mmtt,
6006: --mtl_material_transactions_temp mmtt,
6007: mtl_txn_request_lines mtrl WHERE
6008: mmtt.move_order_line_id = mtrl.line_id
6009: AND mtrl.header_id = p_move_order_header_id
6010: AND mmtt.cartonization_id IS NOT NULL
6011: ORDER BY mmtt.cartonization_id;

Line 6056: mtl_txn_request_lines mtrl

6052: wct.container_item_id,
6053: wct.cartonization_id
6054: FROM
6055: wms_cartonization_temp wct,
6056: mtl_txn_request_lines mtrl
6057: WHERE
6058: wct.move_order_line_id = mtrl.line_id AND
6059: mtrl.header_id = p_hdr_id
6060: order by wct.cartonization_id;

Line 6722: mtl_txn_request_lines mtrl,

6718: rules_table rules_table_type;
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

Line 6746: mtl_txn_request_lines mtrl WHERE

6742: SELECT DISTINCT mmtt.cartonization_id FROM
6743: --2513907 fix
6744: wms_cartonization_temp mmtt,
6745: --mtl_material_transactions_temp mmtt,
6746: mtl_txn_request_lines mtrl WHERE
6747: mmtt.move_order_line_id = mtrl.line_id
6748: AND mtrl.header_id = p_move_order_header_id
6749: AND mmtt.cartonization_id IS NOT NULL
6750: ORDER BY mmtt.cartonization_id;

Line 6781: mtl_txn_request_lines mtrl

6777: wct.container_item_id,
6778: wct.cartonization_id
6779: FROM
6780: wms_cartonization_temp wct,
6781: mtl_txn_request_lines mtrl
6782: WHERE
6783: wct.move_order_line_id = mtrl.line_id AND
6784: mtrl.header_id = p_hdr_id
6785: order by wct.cartonization_id;

Line 7257: mtl_txn_request_lines mtrl,

7253: l_pack_level NUMBER := 0;
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

Line 7281: mtl_txn_request_lines mtrl WHERE

7277: SELECT DISTINCT mmtt.cartonization_id FROM
7278: --2513907 fix
7279: wms_cartonization_temp mmtt,
7280: --mtl_material_transactions_temp mmtt,
7281: mtl_txn_request_lines mtrl WHERE
7282: mmtt.move_order_line_id = mtrl.line_id
7283: AND mtrl.header_id = p_move_order_header_id
7284: AND mmtt.cartonization_id IS NOT NULL
7285: ORDER BY mmtt.cartonization_id;

Line 7331: mtl_txn_request_lines mtrl

7327: wct.container_item_id,
7328: wct.cartonization_id
7329: FROM
7330: wms_cartonization_temp wct,
7331: mtl_txn_request_lines mtrl
7332: WHERE
7333: wct.move_order_line_id = mtrl.line_id AND
7334: mtrl.header_id = p_hdr_id
7335: order by wct.cartonization_id;

Line 7683: mtl_txn_request_lines mtrl,

7679: CURSOR Pick_slip_cur
7680: IS
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

Line 7702: mtl_txn_request_lines mtrl,

7698: CURSOR Pick_slip_sub_cur
7699: IS
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

Line 7721: FROM mtl_txn_request_lines mtrl,

7717:
7718: CURSOR Delivery_cur (p_pick_slip_number NUMBER)
7719: IS
7720: SELECT DISTINCT wda.delivery_id
7721: FROM mtl_txn_request_lines mtrl,
7722: wms_cartonization_temp wct,
7723: wsh_delivery_details wdd ,
7724: wsh_delivery_assignments wda
7725: WHERE mtrl.organization_id = p_org_id

Line 7740: FROM mtl_txn_request_lines mtrl,

7736:
7737: CURSOR Delivery_sub_cur (p_pick_slip_number NUMBER)
7738: IS
7739: SELECT DISTINCT wda.delivery_id
7740: FROM mtl_txn_request_lines mtrl,
7741: wms_cartonization_temp wct,
7742: wsh_delivery_details wdd ,
7743: wsh_delivery_assignments wda
7744: WHERE mtrl.organization_id = p_org_id

Line 7839: mtl_txn_request_lines mtrl

7835: (SELECT wct.transaction_temp_id
7836: FROM wsh_delivery_details wdd ,
7837: wms_cartonization_temp wct ,
7838: wsh_delivery_assignments wda,
7839: mtl_txn_request_lines mtrl
7840: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
7841: AND wdd.source_line_id = wct.demand_source_line
7842: AND wct.move_order_line_id = mtrl.line_id
7843: AND wct.cartonization_id IS NULL

Line 7870: FROM mtl_txn_request_lines mtrl,

7866:
7867: IF p_subinventory_name IS NULL THEN
7868: SELECT wdd.delivery_detail_id BULK COLLECT
7869: INTO l_del_det_id_tab
7870: FROM mtl_txn_request_lines mtrl,
7871: wms_cartonization_temp wct,
7872: wsh_delivery_details wdd ,
7873: wsh_delivery_assignments wda
7874: WHERE mtrl.organization_id = p_org_id

Line 7887: FROM mtl_txn_request_lines mtrl,

7883: AND wda.delivery_id IS NULL;
7884: ELSE
7885: SELECT wdd.delivery_detail_id BULK COLLECT
7886: INTO l_del_det_id_tab
7887: FROM mtl_txn_request_lines mtrl,
7888: wms_cartonization_temp wct,
7889: wsh_delivery_details wdd ,
7890: wsh_delivery_assignments wda
7891: WHERE mtrl.organization_id = p_org_id

Line 7950: mtl_txn_request_lines mtrl

7946: WHERE transaction_temp_id IN
7947: (SELECT wct.transaction_temp_id
7948: FROM wsh_delivery_details wdd ,
7949: wms_cartonization_temp wct,
7950: mtl_txn_request_lines mtrl
7951: WHERE wdd.delivery_detail_id = l_del_det_id_tab (i)
7952: AND wct.pick_slip_number = l_pick_slip
7953: AND wdd.source_line_id = wct.demand_source_line
7954: AND wdd.move_order_line_id = mtrl.line_id

Line 8023: FROM mtl_txn_request_lines mtrl,

8019:
8020: CURSOR Delivery_cur (p_pick_slip_number NUMBER)
8021: IS
8022: SELECT DISTINCT wda.delivery_id
8023: FROM mtl_txn_request_lines mtrl,
8024: wms_cartonization_temp wct,
8025: wsh_delivery_details wdd ,
8026: wsh_delivery_assignments wda
8027: WHERE mtrl.organization_id = p_org_id

Line 8042: FROM mtl_txn_request_lines mtrl,

8038:
8039: CURSOR Delivery_sub_cur (p_pick_slip_number NUMBER)
8040: IS
8041: SELECT DISTINCT wda.delivery_id
8042: FROM mtl_txn_request_lines mtrl,
8043: wms_cartonization_temp wct,
8044: wsh_delivery_details wdd ,
8045: wsh_delivery_assignments wda
8046: WHERE mtrl.organization_id = p_org_id

Line 8104: mtl_txn_request_lines mtrl,

8100: IF p_subinventory_name IS NOT NULL THEN
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

Line 8125: mtl_txn_request_lines mtrl,

8121: ELSE
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

Line 8234: mtl_txn_request_lines mtrl

8230: SELECT DISTINCT wdd.delivery_detail_id BULK COLLECT
8231: INTO l_del_det_id_tab
8232: FROM wsh_delivery_details wdd,
8233: wms_cartonization_temp wct,
8234: mtl_txn_request_lines mtrl
8235: WHERE wct.move_order_line_id = mtrl.line_id
8236: AND mtrl.header_id = p_move_order_header_id
8237: AND wct.organization_id = mtrl.organization_id
8238: AND wct.demand_source_line = wdd.source_line_id

Line 8403: mtl_txn_request_lines mtrl

8399: wct.container_item_id,
8400: wct.cartonization_id
8401: FROM
8402: wms_cartonization_temp wct,
8403: mtl_txn_request_lines mtrl
8404: WHERE
8405: wct.move_order_line_id = mtrl.line_id AND
8406: mtrl.header_id = p_move_order_header_id
8407: ORDER BY wct.cartonization_id;