[Home] [Help]
1176: cii.operational_status_code
1177: FROM csi_item_instances cii,
1178: csi_item_instances_h ciih,
1179: csi_transactions ct,
1180: mtl_material_transactions mmt,
1181: csi_txn_types ctt
1182: WHERE ct.transaction_id = p_transaction_id
1183: AND ct.inv_material_transaction_id = mmt.transaction_id(+)
1184: AND ct.transaction_type_id = ctt.transaction_type_id
1584: mmt.organization_id,
1585: mmt.primary_quantity,
1586: msi.serial_number_control_code,
1587: msi.primary_unit_of_measure
1588: FROM mtl_material_transactions mmt,
1589: mtl_system_items msi
1590: WHERE mmt.transaction_id = p_mtl_txn_id
1591: AND msi.inventory_item_id = mmt.inventory_item_id
1592: AND msi.organization_id = mmt.organization_id;
3244: CURSOR get_srl_code_from_org
3245: IS
3246: SELECT DECODE (msib.serial_number_control_code,1,'NON-SERIAL',
3247: 2, 'SERIAL', 5 ,'SERIAL',6, 'NON-SERIAL','NON-SERIAL') serial_control_code
3248: FROM mtl_material_transactions mmt
3249: ,mtl_system_items_b msib
3250: WHERE mmt.transaction_id = p_mtl_transaction_id
3251: AND mmt.inventory_item_id = msib.inventory_item_id
3252: AND mmt.organization_id = msib.organization_id ;
3254: CURSOR get_srl_code_to_org
3255: IS
3256: SELECT DECODE (msib.serial_number_control_code,1,'NON-SERIAL',
3257: 2, 'SERIAL', 5 ,'SERIAL',6, 'NON-SERIAL','NON-SERIAL') serial_control_code
3258: FROM mtl_material_transactions mmt
3259: ,mtl_system_items_b msib
3260: WHERE mmt.transaction_id = p_mtl_transaction_id
3261: AND mmt.inventory_item_id = msib.inventory_item_id
3262: AND mmt.transfer_organization_id = msib.organization_id ;
3319: AND cii.serial_number is NULL
3320: AND EXISTS (
3321: SELECT 'x'
3322: FROM csi_transactions ct1,
3323: mtl_material_transactions mmt
3324: WHERE ct1.transaction_type_id in (131, 142, 143, 144)
3325: AND ct1.transaction_status_code = 'PENDING'
3326: AND mmt.transaction_id = ct1.inv_material_transaction_id
3327: AND mmt.inventory_item_id = mmt.inventory_item_id
3354: ,citdv.inventory_item_id
3355: ,citdv.transaction_quantity
3356: ,citdv.source_transaction_type
3357: FROM csi_inst_txn_details_v citdv,
3358: mtl_material_transactions mmt,
3359: csi_item_instances_h ciih
3360: WHERE mmt.inventory_item_id = c_inv_item_id
3361: AND mmt.organization_id = c_inv_org_id
3362: AND mmt.shipment_number = c_shipment_number
3396: AND cii.serial_number is NOT NULL
3397: AND EXISTS (
3398: SELECT 'x'
3399: FROM csi_transactions ct1,
3400: mtl_material_transactions mmt
3401: WHERE ct1.transaction_type_id in (131, 142, 143, 144)
3402: AND ct1.transaction_status_code = 'PENDING'
3403: AND mmt.transaction_id = ct1.inv_material_transaction_id
3404: AND mmt.inventory_item_id = mmt.inventory_item_id
3427: ,citdv.source_transaction_type
3428: ,citdv.inventory_item_id
3429: FROM csi_inst_txn_details_v citdv,
3430: csi_item_instances_h ciih,
3431: mtl_material_transactions mmt
3432: WHERE mmt.inventory_item_id = c_inv_item_id
3433: AND citdv.inv_material_transaction_id = mmt.transaction_id
3434: AND mmt.organization_id = c_inv_org_id
3435: AND mmt.shipment_number = c_shipment_number
3484: transfer_organization_id
3485: INTO l_inventory_item_id,
3486: l_shipment_number,
3487: l_xfer_organization_id
3488: FROM mtl_material_transactions
3489: WHERE transaction_id = p_material_transaction_id;
3490:
3491: SELECT source_transaction_type
3492: INTO l_src_transaction_type
3801: l_mtl_txn_date,
3802: l_inventory_item_id,
3803: l_organization_id,
3804: l_mtl_xfer_txn_id
3805: FROM mtl_material_transactions
3806: WHERE transaction_id = p_csi_txn_rec.inv_material_transaction_id;
3807:
3808: debug(' mtl_txn_type_id : '||l_mtl_type_id);
3809: debug(' mtl_src_type_id : '||l_mtl_src_type_id);