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.AHL_OSP_PO_PVT dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 521: -- Delete from the Errors table first so that the subquery can use po_requisitions_interface_all

517: DELETE FROM PO_DISTRIBUTIONS_INTERFACE WHERE
518: INTERFACE_HEADER_ID = l_old_intf_header_id;
519: ELSIF (l_curr_status = G_OSP_REQ_SUB_FAILED_STATUS) THEN
520: -- Requisition Submission had failed earlier
521: -- Delete from the Errors table first so that the subquery can use po_requisitions_interface_all
522: DELETE FROM po_interface_errors
523: WHERE INTERFACE_TRANSACTION_ID in
524: (SELECT transaction_id
525: FROM po_requisitions_interface_all

Line 525: FROM po_requisitions_interface_all

521: -- Delete from the Errors table first so that the subquery can use po_requisitions_interface_all
522: DELETE FROM po_interface_errors
523: WHERE INTERFACE_TRANSACTION_ID in
524: (SELECT transaction_id
525: FROM po_requisitions_interface_all
526: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
527: AND INTERFACE_SOURCE_LINE_ID = l_po_header.OSP_ORDER_ID);
528: DELETE FROM po_requisitions_interface_all
529: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME

Line 528: DELETE FROM po_requisitions_interface_all

524: (SELECT transaction_id
525: FROM po_requisitions_interface_all
526: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
527: AND INTERFACE_SOURCE_LINE_ID = l_po_header.OSP_ORDER_ID);
528: DELETE FROM po_requisitions_interface_all
529: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
530: AND INTERFACE_SOURCE_LINE_ID = l_po_header.OSP_ORDER_ID;
531: END IF;
532: -- End Changes by jaramana on January 7, 2008 for the Requisition ER 6034236