[Home] [Help]
61: IF p_mtl_transaction_id IS NOT NULL AND p_mtl_transaction_id > 0 THEN
62: BEGIN
63: SELECT abs(primary_quantity)
64: INTO l_primary_quantity
65: FROM mtl_material_transactions
66: WHERE transaction_id = p_mtl_transaction_id;
67:
68: debug(' primary_quantity : '||l_primary_quantity);
69:
277: DEBUG('inside '|| l_api_name || 'Get INV OU context');
278: SELECT ood.operating_unit
279: INTO l_txn_ou_context
280: FROM org_organization_definitions ood,
281: mtl_material_transactions mmt,
282: csi_inst_txn_details_v citdv
283: WHERE citdv.transaction_id = p_asset_attrib_rec.transaction_id
284: AND citdv.inv_material_transaction_id = mmt.transaction_id
285: AND mmt.organization_id = ood.organization_id
542: citdv.inv_organization_id,
543: mmt.primary_quantity
544: FROM csi_inst_txn_details_v citdv,
545: csi_i_assets cia,
546: mtl_material_transactions mmt
547: WHERE citdv.source_header_ref_id=l_wip_entity_id
548: AND cia.instance_id=citdv.instance_id
549: AND citdv.inv_material_transaction_id=mmt.transaction_id ;
550:
1052: INTO l_inventory_asset_flag,
1053: l_organization_id,
1054: l_subinventory_code,
1055: l_txn_source_id -- Added for bug#16365883
1056: FROM mtl_material_transactions mmt,
1057: mtl_system_items msi
1058: WHERE mmt.transaction_id = l_mtl_txn_id
1059: AND msi.inventory_item_id = mmt.inventory_item_id
1060: AND msi.organization_id = mmt.organization_id;
1110: -- Added for bug#16365883
1111: BEGIN
1112: SELECT transaction_id,'Y'
1113: INTO l_cogs_mtl_txn_id,l_cogs_recognized
1114: FROM mtl_material_transactions
1115: WHERE transaction_type_id = 10008
1116: AND transaction_source_id = l_txn_source_id;
1117:
1118: EXCEPTION
1615:
1616:
1617: CURSOR item_qty_cur(c_mmt_id IN NUMBER, c_inv_id IN NUMBER) IS
1618: SELECT mmt.primary_quantity
1619: FROM mtl_material_transactions mmt
1620: WHERE mmt.transaction_id = c_mmt_id
1621: AND mmt.inventory_item_id = c_inv_id ;
1622:
1623: CURSOR csi_sub_type_cur (c_transaction_id IN NUMBER) IS