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 637: FROM MTL_INTERORG_PARAMETERS MIP, MTL_MATERIAL_TRANSACTIONS MMT

633: -- Modified for fob stamping project
634: if (i_txn_action_id = 21) THEN
635: SELECT nvl(MMT.fob_point, MIP.fob_point)
636: INTO l_fob_point
637: FROM MTL_INTERORG_PARAMETERS MIP, MTL_MATERIAL_TRANSACTIONS MMT
638: WHERE MIP.from_organization_id = l_org_id
639: AND MIP.to_organization_id = l_txfr_org_id
640: AND MMT.transaction_id = i_txn_id;
641:

Line 645: FROM MTL_INTERORG_PARAMETERS MIP, MTL_MATERIAL_TRANSACTIONS MMT

641:
642: elsif (i_txn_action_id = 12) THEN
643: SELECT nvl(MMT.fob_point, MIP.fob_point)
644: INTO l_fob_point
645: FROM MTL_INTERORG_PARAMETERS MIP, MTL_MATERIAL_TRANSACTIONS MMT
646: WHERE MIP.from_organization_id = l_txfr_org_id
647: AND MIP.to_organization_id = l_org_id
648: AND MMT.transaction_id = i_txn_id;
649: