DBA Data[Home] [Help]

APPS.CSTPSISC dependencies on MTL_INTERORG_PARAMETERS

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: