DBA Data[Home] [Help]

APPS.CSTPPINV dependencies on MTL_INTERCOMPANY_PARAMETERS

Line 824: FROM mtl_intercompany_parameters MIP

820: /* Get the profile status for Internal Sales Order. */
821: BEGIN
822: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)
823: INTO l_tprice_option
824: FROM mtl_intercompany_parameters MIP
825: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
826: AND MIP.flow_type = 1
827: AND MIP.ship_organization_id = (SELECT to_number(HOI.org_information3)
828: FROM hr_organization_information HOI