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.

[Home] [Help]

APPS.WMS_CARTNZN_PUB dependencies on MTL_TXN_REQUEST_LINES

Line 383: mtl_material_transactions_temp mmtt, mtl_txn_request_lines

379:
380: CURSOR c1(mo_hdr_id NUMBER) IS
381: /* added the index hint with the suggestion of apps performance team */
382: SELECT /*+index (mmtt,mtl_material_trans_temp_n14)*/ mmtt.* FROM
383: mtl_material_transactions_temp mmtt, mtl_txn_request_lines
384: mtrl WHERE mtrl.header_id = mo_hdr_id AND
385: mmtt.move_order_line_id = mtrl.line_id AND
386: --2513907 fix
387: mmtt.container_item_id IS null

Line 2741: mtl_txn_request_lines mtrl

2737: wct.CONTAINER_ITEM_ID,
2738: wct.inventory_item_id -- Added for LSP, bug 9087971
2739: FROM
2740: wms_cartonization_temp wct,
2741: mtl_txn_request_lines mtrl
2742: WHERE
2743: wct.move_order_line_id = mtrl.line_id AND
2744: mtrl.header_id = p_header_id AND
2745: wct.transaction_header_id >= 0 -- AND

Line 3273: mtl_txn_request_lines mtrl,

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

Line 3300: mtl_txn_request_lines mtrl WHERE

3296: SELECT DISTINCT mmtt.cartonization_id FROM
3297: --2513907 fix
3298: wms_cartonization_temp mmtt,
3299: --mtl_material_transactions_temp mmtt,
3300: mtl_txn_request_lines mtrl WHERE
3301: mmtt.move_order_line_id = mtrl.line_id
3302: AND mtrl.header_id = p_move_order_header_id
3303: AND mmtt.cartonization_id IS NOT NULL
3304: ORDER BY mmtt.cartonization_id;

Line 3377: mtl_txn_request_lines mtrl

3373: wct.container_item_id,
3374: wct.cartonization_id
3375: FROM
3376: wms_cartonization_temp wct,
3377: mtl_txn_request_lines mtrl
3378: WHERE
3379: wct.move_order_line_id = mtrl.line_id AND
3380: mtrl.header_id = p_hdr_id
3381: order by wct.cartonization_id;

Line 3699: --mtl_material_transactions_temp mmtt, mtl_txn_request_lines

3695: p_transaction_header_id => NULL,
3696: p_input_for_bulk =>p_input_for_bulk);
3697:
3698: --INSERT INTO wms_cartonization_temp SELECT mmtt.* FROM
3699: --mtl_material_transactions_temp mmtt, mtl_txn_request_lines
3700: --mtrl WHERE mtrl.header_id = p_move_order_header_id AND
3701: --mmtt.move_order_line_id = mtrl.line_id;
3702:
3703: ELSE --outbound = 'N'

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

5367: x_return_status=> x_return_status,
5368: x_msg_count => x_msg_count,
5369: x_msg_data => x_msg_data );
5370:
5371: SELECT line_id INTO mlid FROM mtl_txn_request_lines WHERE header_id = 40262
5372: AND roWnum < 2;
5373:
5374: wsh_interface.Get_Max_Load_Qty(p_move_order_line_id => mlid,
5375: x_max_load_quantity => v_qty_per_cont,

Line 5669: mtl_txn_request_lines mtrl WHERE wct.move_order_line_id =

5665: x_msg_data OUT NOCOPY VARCHAR2)
5666: is
5667: CURSOR wct_rows IS
5668: SELECT wct.* FROM wms_cartonization_temp wct,
5669: mtl_txn_request_lines mtrl WHERE wct.move_order_line_id =
5670: mtrl.line_id AND mtrl.header_id = p_m_o_h_id;
5671:
5672: -- patchset J bulk picking ---
5673: -- following cursor will be used for calling from concurrent program --

Line 6004: mtl_txn_request_lines mtrl,

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

Line 6026: mtl_txn_request_lines mtrl,

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

Line 6052: mtl_txn_request_lines mtrl WHERE

6048: SELECT DISTINCT mmtt.cartonization_id FROM
6049: --2513907 fix
6050: wms_cartonization_temp mmtt,
6051: --mtl_material_transactions_temp mmtt,
6052: mtl_txn_request_lines mtrl WHERE
6053: mmtt.move_order_line_id = mtrl.line_id
6054: AND mtrl.header_id = p_move_order_header_id
6055: AND mmtt.cartonization_id IS NOT NULL
6056: ORDER BY mmtt.cartonization_id;

Line 6101: mtl_txn_request_lines mtrl

6097: wct.container_item_id,
6098: wct.cartonization_id
6099: FROM
6100: wms_cartonization_temp wct,
6101: mtl_txn_request_lines mtrl
6102: WHERE
6103: wct.move_order_line_id = mtrl.line_id AND
6104: mtrl.header_id = p_hdr_id
6105: order by wct.cartonization_id;

Line 6781: mtl_txn_request_lines mtrl,

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

Line 6807: mtl_txn_request_lines mtrl WHERE

6803: SELECT DISTINCT mmtt.cartonization_id FROM
6804: --2513907 fix
6805: wms_cartonization_temp mmtt,
6806: --mtl_material_transactions_temp mmtt,
6807: mtl_txn_request_lines mtrl WHERE
6808: mmtt.move_order_line_id = mtrl.line_id
6809: AND mtrl.header_id = p_move_order_header_id
6810: AND mmtt.cartonization_id IS NOT NULL
6811: ORDER BY mmtt.cartonization_id;

Line 6842: mtl_txn_request_lines mtrl

6838: wct.container_item_id,
6839: wct.cartonization_id
6840: FROM
6841: wms_cartonization_temp wct,
6842: mtl_txn_request_lines mtrl
6843: WHERE
6844: wct.move_order_line_id = mtrl.line_id AND
6845: mtrl.header_id = p_hdr_id
6846: order by wct.cartonization_id;

Line 7337: mtl_txn_request_lines mtrl,

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

Line 7364: mtl_txn_request_lines mtrl WHERE

7360: SELECT DISTINCT mmtt.cartonization_id FROM
7361: --2513907 fix
7362: wms_cartonization_temp mmtt,
7363: --mtl_material_transactions_temp mmtt,
7364: mtl_txn_request_lines mtrl WHERE
7365: mmtt.move_order_line_id = mtrl.line_id
7366: AND mtrl.header_id = p_move_order_header_id
7367: AND mmtt.cartonization_id IS NOT NULL
7368: ORDER BY mmtt.cartonization_id;

Line 7414: mtl_txn_request_lines mtrl

7410: wct.container_item_id,
7411: wct.cartonization_id
7412: FROM
7413: wms_cartonization_temp wct,
7414: mtl_txn_request_lines mtrl
7415: WHERE
7416: wct.move_order_line_id = mtrl.line_id AND
7417: mtrl.header_id = p_hdr_id
7418: order by wct.cartonization_id;

Line 7766: mtl_txn_request_lines mtrl,

7762: CURSOR Pick_slip_cur
7763: IS
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

Line 7788: mtl_txn_request_lines mtrl,

7784: CURSOR Pick_slip_sub_cur
7785: IS
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

Line 7810: FROM mtl_txn_request_lines mtrl,

7806:
7807: CURSOR Delivery_cur (p_pick_slip_number NUMBER)
7808: IS
7809: SELECT DISTINCT wda.delivery_id
7810: FROM mtl_txn_request_lines mtrl,
7811: wms_cartonization_temp wct,
7812: wsh_delivery_details wdd ,
7813: wsh_delivery_assignments wda
7814: WHERE mtrl.organization_id = p_org_id

Line 7829: FROM mtl_txn_request_lines mtrl,

7825:
7826: CURSOR Delivery_sub_cur (p_pick_slip_number NUMBER)
7827: IS
7828: SELECT DISTINCT wda.delivery_id
7829: FROM mtl_txn_request_lines mtrl,
7830: wms_cartonization_temp wct,
7831: wsh_delivery_details wdd ,
7832: wsh_delivery_assignments wda
7833: WHERE mtrl.organization_id = p_org_id

Line 7928: mtl_txn_request_lines mtrl

7924: (SELECT wct.transaction_temp_id
7925: FROM wsh_delivery_details wdd ,
7926: wms_cartonization_temp wct ,
7927: wsh_delivery_assignments wda,
7928: mtl_txn_request_lines mtrl
7929: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
7930: AND wdd.source_line_id = wct.demand_source_line
7931: AND wct.move_order_line_id = mtrl.line_id
7932: AND wct.cartonization_id IS NULL

Line 7959: FROM mtl_txn_request_lines mtrl,

7955:
7956: IF p_subinventory_name IS NULL THEN
7957: SELECT wdd.delivery_detail_id BULK COLLECT
7958: INTO l_del_det_id_tab
7959: FROM mtl_txn_request_lines mtrl,
7960: wms_cartonization_temp wct,
7961: wsh_delivery_details wdd ,
7962: wsh_delivery_assignments wda
7963: WHERE mtrl.organization_id = p_org_id

Line 7976: FROM mtl_txn_request_lines mtrl,

7972: AND wda.delivery_id IS NULL;
7973: ELSE
7974: SELECT wdd.delivery_detail_id BULK COLLECT
7975: INTO l_del_det_id_tab
7976: FROM mtl_txn_request_lines mtrl,
7977: wms_cartonization_temp wct,
7978: wsh_delivery_details wdd ,
7979: wsh_delivery_assignments wda
7980: WHERE mtrl.organization_id = p_org_id

Line 8039: mtl_txn_request_lines mtrl

8035: WHERE transaction_temp_id IN
8036: (SELECT wct.transaction_temp_id
8037: FROM wsh_delivery_details wdd ,
8038: wms_cartonization_temp wct,
8039: mtl_txn_request_lines mtrl
8040: WHERE wdd.delivery_detail_id = l_del_det_id_tab (i)
8041: AND wct.pick_slip_number = l_pick_slip
8042: AND wdd.source_line_id = wct.demand_source_line
8043: AND wdd.move_order_line_id = mtrl.line_id

Line 8112: FROM mtl_txn_request_lines mtrl,

8108:
8109: CURSOR Delivery_cur (p_pick_slip_number NUMBER)
8110: IS
8111: SELECT DISTINCT wda.delivery_id
8112: FROM mtl_txn_request_lines mtrl,
8113: wms_cartonization_temp wct,
8114: wsh_delivery_details wdd ,
8115: wsh_delivery_assignments wda
8116: WHERE mtrl.organization_id = p_org_id

Line 8131: FROM mtl_txn_request_lines mtrl,

8127:
8128: CURSOR Delivery_sub_cur (p_pick_slip_number NUMBER)
8129: IS
8130: SELECT DISTINCT wda.delivery_id
8131: FROM mtl_txn_request_lines mtrl,
8132: wms_cartonization_temp wct,
8133: wsh_delivery_details wdd ,
8134: wsh_delivery_assignments wda
8135: WHERE mtrl.organization_id = p_org_id

Line 8193: mtl_txn_request_lines mtrl,

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

Line 8217: mtl_txn_request_lines mtrl,

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

Line 8329: mtl_txn_request_lines mtrl

8325: SELECT DISTINCT wdd.delivery_detail_id BULK COLLECT
8326: INTO l_del_det_id_tab
8327: FROM wsh_delivery_details wdd,
8328: wms_cartonization_temp wct,
8329: mtl_txn_request_lines mtrl
8330: WHERE wct.move_order_line_id = mtrl.line_id
8331: AND mtrl.header_id = p_move_order_header_id
8332: AND wct.organization_id = mtrl.organization_id
8333: AND wct.demand_source_line = wdd.source_line_id

Line 8498: mtl_txn_request_lines mtrl

8494: wct.container_item_id,
8495: wct.cartonization_id
8496: FROM
8497: wms_cartonization_temp wct,
8498: mtl_txn_request_lines mtrl
8499: WHERE
8500: wct.move_order_line_id = mtrl.line_id AND
8501: mtrl.header_id = p_move_order_header_id
8502: ORDER BY wct.cartonization_id;