DBA Data[Home] [Help]

APPS.CST_PAC_ITERATION_PROCESS_PVT dependencies on FND_PROFILE

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

2976: AND c2.organization_id = mmt.transfer_organization_id
2977: AND c1.cost_group_id <> c2.cost_group_id
2978: AND NOT EXISTS (SELECT 'X'
2979: FROM mtl_intercompany_parameters mip
2980: WHERE nvl(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'),0) = 1
2981: AND mip.flow_type = 1
2982: AND nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'),0) = 2
2983: AND mip.ship_organization_id = (select to_number(hoi.org_information3)
2984: from hr_organization_information hoi

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

2978: AND NOT EXISTS (SELECT 'X'
2979: FROM mtl_intercompany_parameters mip
2980: WHERE nvl(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'),0) = 1
2981: AND mip.flow_type = 1
2982: AND nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'),0) = 2
2983: AND mip.ship_organization_id = (select to_number(hoi.org_information3)
2984: from hr_organization_information hoi
2985: where hoi.organization_id = decode(mmt.transaction_action_id,21,
2986: mmt.organization_id,mmt.transfer_organization_id)

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

3162: AND mptrans1.organization_id = mmt1.transfer_organization_id
3163: AND mptrans1.process_enabled_flag = 'N'
3164: AND NOT EXISTS (SELECT 'X'
3165: FROM mtl_intercompany_parameters mip
3166: WHERE nvl(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'),0) = 1
3167: AND mip.flow_type = 1
3168: AND nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'),0) = 2
3169: AND mip.ship_organization_id = (select to_number(hoi.org_information3)
3170: from hr_organization_information hoi

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

3164: AND NOT EXISTS (SELECT 'X'
3165: FROM mtl_intercompany_parameters mip
3166: WHERE nvl(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'),0) = 1
3167: AND mip.flow_type = 1
3168: AND nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'),0) = 2
3169: AND mip.ship_organization_id = (select to_number(hoi.org_information3)
3170: from hr_organization_information hoi
3171: where hoi.organization_id = decode(mmt1.transaction_action_id,21,
3172: mmt1.organization_id,mmt1.transfer_organization_id)