DBA Data[Home] [Help]

APPS.CSTPPINV dependencies on MTL_INTERCOMPANY_PARAMETERS

Line 782: FROM mtl_intercompany_parameters MIP

778: /* Get the profile status for Internal Sales Order. */
779: BEGIN
780: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)
781: INTO l_tprice_option
782: FROM mtl_intercompany_parameters MIP
783: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
784: AND MIP.flow_type = 1
785: AND MIP.ship_organization_id = (SELECT to_number(HOI.org_information3)
786: FROM hr_organization_information HOI