APPS.WMS_CROSS_DOCK_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1598: FROM mtl_txn_request_lines l, mtl_material_transactions_temp t, wsh_delivery_details_ob_grp_v wdd

1594: SELECT
1595: l.line_id, l.backorder_delivery_detail_id,l.inventory_item_id,Nvl(crossdock_type,1)
1596: ,l.transaction_source_type_id,l.txn_source_id
1597: INTO l_mo_line_id,l_del_id,l_item_id,l_crossdock_type,l_transaction_source_type_id,l_txn_supply_source_id
1598: FROM mtl_txn_request_lines l, mtl_material_transactions_temp t, wsh_delivery_details_ob_grp_v wdd
1599: WHERE t.transaction_temp_id=l_temp_id
1600: AND l.backorder_delivery_detail_id = wdd.delivery_detail_id
1601: AND t.move_order_line_id=l.line_id
1602: AND exists (

Line 1616: FROM mtl_txn_request_lines l, mtl_material_transactions_temp t

1612: SELECT
1613: l.line_id, l.backorder_delivery_detail_id,l.inventory_item_id,Nvl(crossdock_type,1)
1614: ,l.transaction_source_type_id,l.txn_source_id
1615: INTO l_mo_line_id,l_del_id,l_item_id,l_crossdock_type,l_transaction_source_type_id,l_txn_supply_source_id
1616: FROM mtl_txn_request_lines l, mtl_material_transactions_temp t
1617: WHERE t.transaction_temp_id=l_temp_id
1618: AND t.move_order_line_id=l.line_id;
1619:
1620: END;

Line 1671: FROM mtl_material_transactions_temp t,

1667: INTO l_prim_qty ,l_item_id,l_sub,
1668: l_loc,l_rev,l_transaction_type_id,
1669: l_transfer_lpn_id,l_cnt_lpn_id,l_prim_uom
1670: ,l_lot_control_code, l_serial_control_code
1671: FROM mtl_material_transactions_temp t,
1672: mtl_system_items i
1673: WHERE t.transaction_temp_id=l_temp_id
1674: AND t.organization_id=l_org_id
1675: AND t.organization_id =i.organization_id

Line 1691: WHERE (transaction_temp_id in (select TRANSACTION_TEMP_ID from mtl_material_transactions_temp where PARENT_LINE_ID=l_temp_id)

1687: -- Get lot info. Will always be only one lot
1688: SELECT lot_number,serial_transaction_temp_id INTO l_lot,
1689: l_serial_temp_id
1690: FROM mtl_transaction_lots_temp
1691: WHERE (transaction_temp_id in (select TRANSACTION_TEMP_ID from mtl_material_transactions_temp where PARENT_LINE_ID=l_temp_id)
1692: or transaction_temp_id = l_temp_id ) -- 11701595
1693: and rownum=1; -- Modified for Bug#8489892
1694:
1695: mydebug('l_serial_temp_id is '||l_serial_temp_id);

Line 2829: FROM mtl_material_transactions_temp mmtt

2825: , mtrl.backorder_delivery_detail_id
2826: INTO l_txn_src_type_id
2827: , l_move_order_line_id
2828: , l_backorder_delivery_detail_id
2829: FROM mtl_material_transactions_temp mmtt
2830: , mtl_txn_request_lines mtrl
2831: , mtl_txn_request_headers mtrh
2832: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
2833: AND mmtt.move_order_line_id = mtrl.line_id