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_AUDIT_ENGAGEMENT_PVT dependencies on AMW_AP_ASSOCIATIONS_S

Line 1024: from amw_ap_associations src ,amw_ap_associations dest

1020: select distinct src.pk1 src_pk1,src.pk2 src_pk2,src.pk3 src_pk3,src.pk4 src_pk4,
1021: dest.pk1 dest_pk1,dest.pk2 dest_pk2,dest.pk3 dest_pk3,
1022: dest.pk4 dest_pk4,src.audit_procedure_rev_id src_audit_procedure_rev_id,
1023: dest.audit_procedure_rev_id dest_audit_procedure_rev_id
1024: from amw_ap_associations src ,amw_ap_associations dest
1025: where src.pk1=p_source_project_id and dest.pk1=p_dest_project_id
1026: and src.OBJECT_TYPE='PROJECT' and src.association_creation_date is not null
1027: and dest.OBJECT_TYPE ='PROJECT_NEW' and dest.association_creation_date is not null
1028: and src.pk2=dest.pk2 and src.pk3=dest.pk3

Line 1164: SELECT AMW_AP_ASSOCIATIONS_S.nextval,

1160: pk3,
1161: pk4,
1162: object_type,
1163: object_version_number)
1164: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1165: SYSDATE ,
1166: FND_GLOBAL.USER_ID,
1167: SYSDATE,
1168: FND_GLOBAL.USER_ID,

Line 1254: SELECT AMW_AP_ASSOCIATIONS_S.nextval,

1250: pk3,
1251: pk4,
1252: object_type,
1253: object_version_number)
1254: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1255: SYSDATE ,
1256: FND_GLOBAL.USER_ID,
1257: SYSDATE,
1258: FND_GLOBAL.USER_ID,

Line 1318: -- from amw_ap_associations dest ,amw_ap_associations src

1314:
1315: For ap_task_icm in c_task_icm
1316: LOOP
1317: -- select src.audit_procedure_rev_id into l_audit_procedure_rev_id
1318: -- from amw_ap_associations dest ,amw_ap_associations src
1319: -- where dest.pk1=p_dest_project_id and src.pk1=p_source_project_id
1320: -- and src.audit_procedure_id=dest.audit_procedure_id
1321: -- and src.pk4=ap_task_icm.src_task_id
1322: -- and src.audit_procedure_rev_id=dest.audit_procedure_rev_id;

Line 1329: from amw_ap_associations dest ,amw_ap_associations src

1325: set pk4= ap_task_icm.dest_task_id
1326: where pk1=p_dest_project_id
1327: and audit_procedure_id in (
1328: select src.audit_procedure_id
1329: from amw_ap_associations dest ,amw_ap_associations src
1330: where dest.pk1=p_dest_project_id and src.pk1=p_source_project_id
1331: and src.audit_procedure_id=dest.audit_procedure_id
1332: and src.pk4=ap_task_icm.src_task_id
1333: and src.association_creation_date is null);

Line 1340: from amw_ap_associations dest ,amw_ap_associations src

1336: set pk3_value=ap_task_icm.dest_task_id
1337: where pk1_value=to_char(p_dest_project_id) and pk3_value=-1
1338: and pk4_value in (
1339: select src.audit_procedure_rev_id
1340: from amw_ap_associations dest ,amw_ap_associations src
1341: where dest.pk1=p_dest_project_id and src.pk1=p_source_project_id
1342: and src.audit_procedure_id=dest.audit_procedure_id
1343: and src.pk4=ap_task_icm.src_task_id
1344: and src.association_creation_date is null) ;

Line 1412: from amw_ap_associations src ,amw_ap_associations dest

1408: select distinct src.pk1 src_pk1,src.pk2 src_pk2,src.pk3 src_pk3,src.pk4 src_pk4,
1409: dest.pk1 dest_pk1,dest.pk2 dest_pk2,dest.pk3 dest_pk3,
1410: dest.pk4 dest_pk4,src.audit_procedure_rev_id src_audit_procedure_rev_id,
1411: dest.audit_procedure_rev_id dest_audit_procedure_rev_id
1412: from amw_ap_associations src ,amw_ap_associations dest
1413: where src.pk1=p_source_project_id and dest.pk1=p_dest_project_id
1414: and src.OBJECT_TYPE='PROJECT' and src.association_creation_date is not null
1415: and dest.OBJECT_TYPE ='PROJECT_NEW' and dest.association_creation_date is not null
1416: and src.pk2=dest.pk2 and src.pk3=dest.pk3

Line 1552: SELECT AMW_AP_ASSOCIATIONS_S.nextval,

1548: pk3,
1549: pk4,
1550: object_type,
1551: object_version_number)
1552: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1553: SYSDATE ,
1554: FND_GLOBAL.USER_ID,
1555: SYSDATE,
1556: FND_GLOBAL.USER_ID,

Line 1632: SELECT AMW_AP_ASSOCIATIONS_S.nextval,

1628: pk3,
1629: pk4,
1630: object_type,
1631: object_version_number)
1632: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1633: SYSDATE ,
1634: FND_GLOBAL.USER_ID,
1635: SYSDATE,
1636: FND_GLOBAL.USER_ID,

Line 1694: -- from amw_ap_associations dest ,amw_ap_associations src

1690:
1691: For ap_task_icm in c_task_icm
1692: LOOP
1693: -- select src.audit_procedure_rev_id into l_audit_procedure_rev_id
1694: -- from amw_ap_associations dest ,amw_ap_associations src
1695: -- where dest.pk1=p_dest_project_id and src.pk1=p_source_project_id
1696: -- and src.audit_procedure_id=dest.audit_procedure_id
1697: -- and src.pk4=ap_task_icm.src_task_id
1698: -- and src.audit_procedure_rev_id=dest.audit_procedure_rev_id;

Line 1705: from amw_ap_associations dest ,amw_ap_associations src

1701: set pk4= ap_task_icm.dest_task_id
1702: where pk1=p_dest_project_id
1703: and audit_procedure_id in (
1704: select src.audit_procedure_id
1705: from amw_ap_associations dest ,amw_ap_associations src
1706: where dest.pk1=p_dest_project_id and src.pk1=p_source_project_id
1707: and src.audit_procedure_id=dest.audit_procedure_id
1708: and src.pk4=ap_task_icm.src_task_id
1709: and src.association_creation_date is null);

Line 1716: from amw_ap_associations dest ,amw_ap_associations src

1712: set pk3_value=ap_task_icm.dest_task_id
1713: where pk1_value=to_char(p_dest_project_id) and pk3_value=-1
1714: and pk4_value in (
1715: select src.audit_procedure_rev_id
1716: from amw_ap_associations dest ,amw_ap_associations src
1717: where dest.pk1=p_dest_project_id and src.pk1=p_source_project_id
1718: and src.audit_procedure_id=dest.audit_procedure_id
1719: and src.pk4=ap_task_icm.src_task_id
1720: and src.association_creation_date is null) ;