DBA Data[Home] [Help]

APPS.CST_PAC_ITERATION_PROCESS_PVT dependencies on MTL_INTERCOMPANY_PARAMETERS

Line 3135: FROM mtl_intercompany_parameters mip

3131: AND c1.cost_group_id = ccg1.cost_group_id
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)

Line 3321: FROM mtl_intercompany_parameters mip

3317: ccga.organization_id = mmt1.transfer_organization_id)))
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)