DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEF_COMMON dependencies on MTL_INTERCOMPANY_PARAMETERS

Line 1145: mtl_intercompany_parameters intcomp

1141: 'Y' intercompany_flag
1142: FROM ap_tax_codes_all ap_codes,
1143: ar_vat_tax_all_b ar_codes,
1144: financials_system_params_all fsp,
1145: mtl_intercompany_parameters intcomp
1146: WHERE ap_codes.tax_type NOT IN ('AWT','TAX_GROUP')
1147: AND decode(l_multi_org_flag,'N',l_org_id,ap_codes.org_id) = decode(l_multi_org_flag,'N',l_org_id,fsp.org_id)
1148: AND decode(l_multi_org_flag,'N',l_org_id,ap_codes.org_id) = decode(l_multi_org_flag,'N',l_org_id,intcomp.sell_organization_id)
1149: AND decode(l_multi_org_flag,'N',l_org_id,ar_codes.org_id) = decode(l_multi_org_flag,'N',l_org_id,intcomp.ship_organization_id)

Line 1266: mtl_intercompany_parameters intcomp

1262: 'Y' intercompany_flag
1263: FROM ar_vat_tax_all_b ar_codes,
1264: ap_tax_codes_all ap_codes,
1265: ar_system_parameters_all asp,
1266: mtl_intercompany_parameters intcomp
1267: WHERE ar_codes.tax_type <> 'TAX_GROUP'
1268: AND decode(l_multi_org_flag,'N',l_org_id,asp.org_id) = decode(l_multi_org_flag,'N',l_org_id,ar_codes.org_id)
1269: AND decode(l_multi_org_flag,'N',l_org_id,ap_codes.org_id) = decode(l_multi_org_flag,'N',l_org_id,intcomp.sell_organization_id)
1270: AND decode(l_multi_org_flag,'N',l_org_id,ar_codes.org_id) = decode(l_multi_org_flag,'N',l_org_id,intcomp.ship_organization_id)