DBA Data[Home] [Help]

APPS.CST_PAC_ITERATION_PROCESS_PVT dependencies on FND_PROFILE

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

3132: AND c2.cost_group_id = ccg2.cost_group_id
3133: AND ccg1.legal_entity = ccg2.legal_entity
3134: AND NOT EXISTS (SELECT 'X'
3135: FROM mtl_intercompany_parameters mip
3136: WHERE nvl(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'),0) = 1
3137: AND mip.flow_type = 1
3138: AND nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'),0) = 2
3139: AND mip.ship_organization_id = (select to_number(hoi.org_information3)
3140: from hr_organization_information hoi

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

3134: AND NOT EXISTS (SELECT 'X'
3135: FROM mtl_intercompany_parameters mip
3136: WHERE nvl(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'),0) = 1
3137: AND mip.flow_type = 1
3138: AND nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'),0) = 2
3139: AND mip.ship_organization_id = (select to_number(hoi.org_information3)
3140: from hr_organization_information hoi
3141: where hoi.organization_id = decode(mmt.transaction_action_id,21,
3142: mmt.organization_id,mmt.transfer_organization_id)

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

3318: AND mptrans1.organization_id = mmt1.transfer_organization_id
3319: AND mptrans1.process_enabled_flag = 'N'
3320: AND NOT EXISTS (SELECT 'X'
3321: FROM mtl_intercompany_parameters mip
3322: WHERE nvl(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'),0) = 1
3323: AND mip.flow_type = 1
3324: AND nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'),0) = 2
3325: AND mip.ship_organization_id = (select to_number(hoi.org_information3)
3326: from hr_organization_information hoi

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

3320: AND NOT EXISTS (SELECT 'X'
3321: FROM mtl_intercompany_parameters mip
3322: WHERE nvl(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'),0) = 1
3323: AND mip.flow_type = 1
3324: AND nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'),0) = 2
3325: AND mip.ship_organization_id = (select to_number(hoi.org_information3)
3326: from hr_organization_information hoi
3327: where hoi.organization_id = decode(mmt1.transaction_action_id,21,
3328: mmt1.organization_id,mmt1.transfer_organization_id)