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.PO_PDOI_DISTRIBUTIONS_SV3 dependencies on PA_EXPEND_TYP_SYS_LINKS

Line 1343: with respect to pa_expend_typ_sys_links.Because of this the project

1339: IF x_destination_type_code = 'INVENTORY' then
1340:
1341: /* bug 9412338/9831707 The expenditure_type was being validated with
1342: respect to the pa_expenditure_types, However it should be validated
1343: with respect to pa_expend_typ_sys_links.Because of this the project
1344: validations were failing.Added the table pa_expend_typ_sys_links to the
1345: from clause ,join condition in the where clause.System_linkage_function
1346: should be validated with the value in pa_expend_typ_sys_links table.*/
1347:

Line 1344: validations were failing.Added the table pa_expend_typ_sys_links to the

1340:
1341: /* bug 9412338/9831707 The expenditure_type was being validated with
1342: respect to the pa_expenditure_types, However it should be validated
1343: with respect to pa_expend_typ_sys_links.Because of this the project
1344: validations were failing.Added the table pa_expend_typ_sys_links to the
1345: from clause ,join condition in the where clause.System_linkage_function
1346: should be validated with the value in pa_expend_typ_sys_links table.*/
1347:
1348: SELECT 'Y' into x_valid2

Line 1346: should be validated with the value in pa_expend_typ_sys_links table.*/

1342: respect to the pa_expenditure_types, However it should be validated
1343: with respect to pa_expend_typ_sys_links.Because of this the project
1344: validations were failing.Added the table pa_expend_typ_sys_links to the
1345: from clause ,join condition in the where clause.System_linkage_function
1346: should be validated with the value in pa_expend_typ_sys_links table.*/
1347:
1348: SELECT 'Y' into x_valid2
1349: FROM sys.dual
1350: WHERE x_expenditure_type IS NULL

Line 1353: pa_expend_typ_sys_links sl -- Bug 9412338/9831707

1349: FROM sys.dual
1350: WHERE x_expenditure_type IS NULL
1351: OR EXISTS( SELECT 'Valid Expenditure Type'
1352: FROM pa_expenditure_types pet,
1353: pa_expend_typ_sys_links sl -- Bug 9412338/9831707
1354: WHERE pet.expenditure_type = x_expenditure_type
1355: AND pet.expenditure_type = sl.expenditure_type --bug9412338/9831707
1356: AND sl.system_linkage_function = 'VI' --bug9412338/9831707
1357: );