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_ASL_API_PVT dependencies on CHV_AUTHORIZATIONS_GT

Line 561: FROM chv_authorizations_gt

557: program_application_id ,
558: program_id ,
559: program_update_date ,
560: using_organization_id
561: FROM chv_authorizations_gt
562: WHERE user_key IN
563: (SELECT user_key
564: FROM po_approved_supplier_list_gt
565: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)

Line 1055: FROM chv_authorizations_gt CHVGT,

1051: CHVGT.request_id ,
1052: CHVGT.program_application_id ,
1053: CHVGT.program_id ,
1054: CHVGT.program_update_date
1055: FROM chv_authorizations_gt CHVGT,
1056: po_approved_supplier_list_gt ASLGT
1057: WHERE CHVGT.user_key = ASLGT.user_key
1058: AND CHVGT.reference_id = CHV.reference_id
1059: AND CHVGT.using_organization_id = CHV.using_organization_id

Line 1071: FROM chv_authorizations_gt CHVGT,

1067: (SELECT CHVGT.reference_id ,
1068: CHVGT.using_organization_id ,
1069: CHVGT.authorization_code ,
1070: CHVGT.authorization_sequence_dsp
1071: FROM chv_authorizations_gt CHVGT,
1072: po_approved_supplier_list_gt ASLGT
1073: WHERE CHVGT.user_key = ASLGT.user_key
1074: AND CHVGT.reference_id = CHV.reference_id
1075: AND CHVGT.using_organization_id = CHV.using_organization_id

Line 1305: FROM chv_authorizations_gt CHVGT,

1301: WHERE (reference_id, using_organization_id, authorization_code) IN
1302: (SELECT CHVGT.reference_id ,
1303: CHVGT.using_organization_id ,
1304: CHVGT.authorization_code
1305: FROM chv_authorizations_gt CHVGT,
1306: po_approved_supplier_list_gt ASLGT
1307: WHERE ASLGT.user_key = CHVGT.user_key
1308: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_DELETE
1309: AND CHVGT.reference_id = CHV.reference_id