APPS.CSTPSISC dependencies on MTL_MATERIAL_TRANSACTIONS

Line 393: FROM mtl_material_transactions

389: -- all other cases for asset items
390: l_stmt_num := 70;
391: SELECT primary_quantity, organization_id, transfer_organization_id
392: INTO l_txn_qty, l_org_id, l_txfr_org_id
393: FROM mtl_material_transactions
394: WHERE transaction_id = i_txn_id;
395:
396: /* For intransit shipments, FOB shipment, this function is called twice -
397: once for the sending org and once for the receiving org.

Line 687: FROM MTL_INTERORG_PARAMETERS MIP, MTL_MATERIAL_TRANSACTIONS MMT

683: -- Modified for fob stamping project
684: if (i_txn_action_id = 21) THEN
685: SELECT nvl(MMT.fob_point, MIP.fob_point)
686: INTO l_fob_point
687: FROM MTL_INTERORG_PARAMETERS MIP, MTL_MATERIAL_TRANSACTIONS MMT
688: WHERE MIP.from_organization_id = l_org_id
689: AND MIP.to_organization_id = l_txfr_org_id
690: AND MMT.transaction_id = i_txn_id;
691:

Line 695: FROM MTL_INTERORG_PARAMETERS MIP, MTL_MATERIAL_TRANSACTIONS MMT

691:
692: elsif (i_txn_action_id = 12) THEN
693: SELECT nvl(MMT.fob_point, MIP.fob_point)
694: INTO l_fob_point
695: FROM MTL_INTERORG_PARAMETERS MIP, MTL_MATERIAL_TRANSACTIONS MMT
696: WHERE MIP.from_organization_id = l_txfr_org_id
697: AND MIP.to_organization_id = l_org_id
698: AND MMT.transaction_id = i_txn_id;
699: