[Home] [Help]
84: AND secondary_inventory_name = subinv_code;
85:
86: CURSOR c_transaction_type( txn_type_id IN NUMBER) IS
87: SELECT t.transaction_source_type_id
88: FROM mtl_transaction_types t, mtl_txn_source_types st
89: WHERE t.transaction_source_type_id = st.transaction_source_type_id
90: AND t.transaction_type_id = txn_type_id;
91: CURSOR c_get_delivery_detail IS
92: SELECT delivery_detail_id