DBA Data[Home] [Help]

APPS.CST_PERIODIC_AVERAGE_PROC_CP dependencies on FND_PROFILE

Line 1220: WHERE nvl(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'),0) = 1

1216: AND mmt1.organization_id = mp1.organization_id
1217: AND nvl(mp1.process_enabled_flag,'N') = 'N'
1218: AND EXISTS (SELECT 'X'
1219: FROM mtl_intercompany_parameters mip
1220: WHERE nvl(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'),0) = 1
1221: AND mip.flow_type = 1
1222: AND nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'),0) = 2
1223: AND mip.ship_organization_id = (select to_number(hoi.org_information3)
1224: from hr_organization_information hoi

Line 1222: AND nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'),0) = 2

1218: AND EXISTS (SELECT 'X'
1219: FROM mtl_intercompany_parameters mip
1220: WHERE nvl(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'),0) = 1
1221: AND mip.flow_type = 1
1222: AND nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'),0) = 2
1223: AND mip.ship_organization_id = (select to_number(hoi.org_information3)
1224: from hr_organization_information hoi
1225: where hoi.organization_id = decode(mmt1.transaction_action_id,21,
1226: mmt1.organization_id,mmt1.transfer_organization_id)