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.AMW_LOAD_SOD_DATA dependencies on FND_RESPONSIBILITY_VL

Line 751: Fnd_Responsibility_Vl to get the responsibility_id from responsibility_name

747: If the PK1 is Null, then it means that the responsibility_name in the
748: interface table is invalid.
749:
750: Populating of the Pk1 will avoid the joining of interface table with
751: Fnd_Responsibility_Vl to get the responsibility_id from responsibility_name
752: */
753: UPDATE amw_cst_waiver_interface acwi
754: SET acwi.pk1 = ( SELECT responsibility_id
755: FROM fnd_responsibility_vl resp

Line 755: FROM fnd_responsibility_vl resp

751: Fnd_Responsibility_Vl to get the responsibility_id from responsibility_name
752: */
753: UPDATE amw_cst_waiver_interface acwi
754: SET acwi.pk1 = ( SELECT responsibility_id
755: FROM fnd_responsibility_vl resp
756: WHERE resp.application_id = acwi.pk2
757: AND resp.responsibility_name = acwi.responsibility_name)
758: WHERE acwi.batch_id = p_batch_id
759: AND acwi.object_type = 'RESP'

Line 1121: Fnd_Responsibility_Vl to get the responsibility_id from responsibility_name

1117: If the PK1 is Null, then it means that the responsibility_name in the
1118: interface table is invalid.
1119:
1120: Populating of the Pk1 will avoid the joining of interface table with
1121: Fnd_Responsibility_Vl to get the responsibility_id from responsibility_name
1122: */
1123: UPDATE amw_cst_waiver_interface acwi
1124: SET acwi.pk1 = ( SELECT responsibility_id
1125: FROM fnd_responsibility_vl resp

Line 1125: FROM fnd_responsibility_vl resp

1121: Fnd_Responsibility_Vl to get the responsibility_id from responsibility_name
1122: */
1123: UPDATE amw_cst_waiver_interface acwi
1124: SET acwi.pk1 = ( SELECT responsibility_id
1125: FROM fnd_responsibility_vl resp
1126: WHERE resp.application_id = acwi.pk2
1127: AND resp.responsibility_name = acwi.responsibility_name)
1128: WHERE acwi.object_type = 'RESP'
1129: AND acwi.responsibility_name IS NOT NULL

Line 1588: FROM FND_RESPONSIBILITY_VL RESP,

1584: SELECT APPL.APPLICATION_ID,APPL.APPLICATION_NAME,RESP.RESPONSIBILITY_NAME
1585: BULK COLLECT INTO l_appl_id_list,
1586: l_appl_name_list,
1587: l_resp_name_list
1588: FROM FND_RESPONSIBILITY_VL RESP,
1589: FND_APPLICATION_VL APPL
1590: WHERE RESP.RESPONSIBILITY_ID = l_resp_id_list(i)
1591: AND RESP.START_DATE <= SYSDATE
1592: AND (RESP.END_DATE >= SYSDATE OR RESP.END_DATE IS NULL)

Line 1652: FROM FND_RESPONSIBILITY_VL RESP,

1648: SELECT APPL.APPLICATION_ID,APPL.APPLICATION_NAME,RESP.RESPONSIBILITY_NAME
1649: BULK COLLECT INTO l_appl_id_list,
1650: l_appl_name_list,
1651: l_resp_name_list
1652: FROM FND_RESPONSIBILITY_VL RESP,
1653: FND_APPLICATION_VL APPL
1654: WHERE RESP.RESPONSIBILITY_ID = l_function_id_list(i)
1655: AND RESP.START_DATE <= SYSDATE
1656: AND (RESP.END_DATE >= SYSDATE OR RESP.END_DATE IS NULL)

Line 1863: FROM FND_RESPONSIBILITY_VL RESP,

1859: SELECT APPL.APPLICATION_ID,APPL.APPLICATION_NAME,RESP.RESPONSIBILITY_NAME
1860: BULK COLLECT INTO l_appl_id_list,
1861: l_appl_name_list,
1862: l_resp_name_list
1863: FROM FND_RESPONSIBILITY_VL RESP,
1864: FND_APPLICATION_VL APPL
1865: WHERE RESP.RESPONSIBILITY_ID = l_resp_id_list(i)
1866: AND RESP.START_DATE <= SYSDATE
1867: AND (RESP.END_DATE >= SYSDATE OR RESP.END_DATE IS NULL)