DBA Data[Home] [Help]

APPS.CSTPSISC dependencies on MTL_INTERORG_PARAMETERS

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: