[Home] [Help]
37: IS
38: CURSOR Dup_Staging_txn_cur IS
39: SELECT 'Y'
40: FROM mtl_material_transactions mmt ,
41: mtl_material_transactions_temp mmtt,
42: wsh_delivery_assignments wda,
43: wsh_delivery_details wdd
44: WHERE mmtt.transaction_temp_id = p_transaction_id
45: AND wda.delivery_id = p_delivery_id
76: , x_msg_data OUT NOCOPY VARCHAR2
77: , x_return_status OUT NOCOPY VARCHAR2
78: , p_label_type_info IN INV_LABEL.label_type_rec
79: , p_transaction_id IN NUMBER
80: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
81: , p_transaction_identifier IN NUMBER
82: ) IS
83:
84: l_delivery_id NUMBER;
119:
120: CURSOR c_cart_shipping IS
121: SELECT wda.delivery_id, mmtt.organization_id, mmtt.subinventory_code
122: FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd,
123: wsh_delivery_details wdd, mtl_material_transactions_temp mmtt
124: WHERE mmtt.move_order_line_id = wdd.move_order_line_id
125: AND wda.delivery_detail_id = wdd.delivery_detail_id
126: AND wnd.delivery_id = wda.delivery_id
127: AND mmtt.transaction_temp_id = p_transaction_id;
130:
131: CURSOR c_cart_shipping_pkg IS
132: SELECT DISTINCT(wda.delivery_id)
133: FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd,
134: wsh_delivery_details wdd, mtl_material_transactions_temp mmtt
135: --wms_packaging_hist wph
136: WHERE mmtt.move_order_line_id = wdd.move_order_line_id (+)
137: AND wda.delivery_detail_id (+) = wdd.delivery_detail_id
138: AND wnd.delivery_id (+) = wda.delivery_id
145: derive the delivery_detail_id from the WDD and then eventually the delivery_id.
146: */
147: /*CURSOR c_mmtt_temp_id IS
148: SELECT move_order_line_id
149: FROM mtl_material_transactions_temp mmtt
150: WHERE mmtt.transaction_temp_id = p_transaction_id;
151:
152:
153:
165: /* Combined the above three cursors into one */
166: CURSOR c_mmtt_pick_drop IS
167: SELECT wda.delivery_id, mmtt.organization_id, mmtt.transfer_subinventory
168: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
169: , mtl_material_transactions_temp mmtt
170: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
171: AND wdd.move_order_line_id = mmtt.move_order_line_id
172: AND mmtt.transaction_temp_id = p_transaction_id;
173:
1297: , x_msg_data OUT NOCOPY VARCHAR2
1298: , x_return_status OUT NOCOPY VARCHAR2
1299: , p_label_type_info IN INV_LABEL.label_type_rec
1300: , p_transaction_id IN NUMBER
1301: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
1302: , p_transaction_identifier IN NUMBER
1303: ) IS
1304: l_variable_data_tbl INV_LABEL.label_tbl_type;
1305: BEGIN