eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on PA_PROJECT_TYPES_ALL

Line 439: FROM pa_project_types_all ptype,

435: AND APID.line_type_lookup_code IN ('ITEM','ACCRUAL')
436: AND apid.assets_tracking_flag = 'Y'
437: AND ( APID.project_id IS NULL
438: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
439: FROM pa_project_types_all ptype,
440: pa_projects_all proj
441: WHERE proj.project_type = ptype.project_type
442: AND ptype.org_id = proj.org_id
443: AND proj.project_id = APID.project_id

Line 488: FROM pa_project_types_all ptype,

484: apid.related_id) =
485: item.invoice_distribution_id -- Bug 12660674
486: AND ( APID.project_id IS NULL
487: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
488: FROM pa_project_types_all ptype,
489: pa_projects_all proj
490: WHERE proj.project_type = ptype.project_type
491: AND ptype.org_id = proj.org_id
492: AND proj.project_id = APID.project_id

Line 533: FROM pa_project_types_all ptype,

529: AND APID.assets_tracking_flag = 'Y'
530: AND NVL(APID.charge_applicable_to_dist_id,APID.corrected_invoice_dist_id) IS NULL --Bug#14495604 added in case of invoice corrections
531: AND ( APID.project_id IS NULL
532: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
533: FROM pa_project_types_all ptype,
534: pa_projects_all proj
535: WHERE proj.project_type = ptype.project_type
536: AND ptype.org_id = proj.org_id
537: AND proj.project_id = APID.project_id

Line 575: FROM pa_project_types_all ptype,

571: AND satx.charge_applicable_to_dist_id IS NOT NULL
572: AND satx.charge_applicable_to_dist_id = item.invoice_distribution_id
573: AND ( satx.project_id IS NULL
574: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
575: FROM pa_project_types_all ptype,
576: pa_projects_all proj
577: WHERE proj.project_type = ptype.project_type
578: AND ptype.org_id = proj.org_id
579: AND proj.project_id = satx.project_id

Line 938: FROM pa_project_types_all ptype,

934: AND APID.line_type_lookup_code IN ('ITEM','ACCRUAL')
935: AND apid.assets_tracking_flag = 'Y'
936: AND ( APID.project_id IS NULL
937: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
938: FROM pa_project_types_all ptype,
939: pa_projects_all proj
940: WHERE proj.project_type = ptype.project_type
941: AND ptype.org_id = proj.org_id
942: AND proj.project_id = APID.project_id

Line 986: FROM pa_project_types_all ptype,

982: apid.related_id) =
983: item.invoice_distribution_id -- Bug 12660674
984: AND ( APID.project_id IS NULL
985: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
986: FROM pa_project_types_all ptype,
987: pa_projects_all proj
988: WHERE proj.project_type = ptype.project_type
989: AND ptype.org_id = proj.org_id
990: AND proj.project_id = APID.project_id

Line 1031: FROM pa_project_types_all ptype,

1027: AND APID.assets_tracking_flag = 'Y'
1028: AND NVL(APID.charge_applicable_to_dist_id,APID.corrected_invoice_dist_id) IS NULL --Bug#14495604 added in case of invoice corrections
1029: AND ( APID.project_id IS NULL
1030: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
1031: FROM pa_project_types_all ptype,
1032: pa_projects_all proj
1033: WHERE proj.project_type = ptype.project_type
1034: AND ptype.org_id = proj.org_id
1035: AND proj.project_id = APID.project_id

Line 1074: FROM pa_project_types_all ptype,

1070: AND satx.charge_applicable_to_dist_id IS NOT NULL
1071: AND satx.charge_applicable_to_dist_id = item.invoice_distribution_id
1072: AND ( satx.project_id IS NULL
1073: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
1074: FROM pa_project_types_all ptype,
1075: pa_projects_all proj
1076: WHERE proj.project_type = ptype.project_type
1077: AND ptype.org_id = proj.org_id
1078: AND proj.project_id = satx.project_id

Line 1886: FROM pa_project_types_all ptype,

1882: -- Bug 13821160: Added code to skip capital project dist
1883: AND ( APID.project_id IS NULL
1884: OR
1885: (SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
1886: FROM pa_project_types_all ptype,
1887: pa_projects_all proj
1888: WHERE proj.project_type = ptype.project_type
1889: AND ptype.org_id = proj.org_id
1890: AND proj.project_id = APID.project_id