DBA Data[Home] [Help]

APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on MTL_INTERCOMPANY_PARAMETERS

Line 1786: FROM mtl_intercompany_parameters mip

1782: where mp2.organization_id = mmt.transfer_organization_id
1783: AND mp2.process_enabled_flag = 'Y'))
1784: OR (mmt.transaction_source_type_id in (7,8)
1785: AND EXISTS (SELECT 'X'
1786: FROM mtl_intercompany_parameters mip
1787: WHERE nvl(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'),0) = 1
1788: AND mip.flow_type = 1
1789: AND nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'),0) = 2
1790: AND mip.ship_organization_id = (select to_number(hoi.org_information3)

Line 1975: FROM mtl_intercompany_parameters mip

1971: where mp2.organization_id = mmt.transfer_organization_id
1972: AND mp2.process_enabled_flag = 'Y'))
1973: OR (mmt.transaction_source_type_id in (7,8)
1974: AND EXISTS (SELECT 'X'
1975: FROM mtl_intercompany_parameters mip
1976: WHERE nvl(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'),0) = 1
1977: AND mip.flow_type = 1
1978: AND nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'),0) = 2
1979: AND mip.ship_organization_id = (select to_number(hoi.org_information3)