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 513: -- Delete from the Errors table first so that the subquery can use po_requisitions_interface_all

509: DELETE FROM PO_DISTRIBUTIONS_INTERFACE WHERE
510: INTERFACE_HEADER_ID = l_old_intf_header_id;
511: ELSIF (l_curr_status = G_OSP_REQ_SUB_FAILED_STATUS) THEN
512: -- Requisition Submission had failed earlier
513: -- Delete from the Errors table first so that the subquery can use po_requisitions_interface_all
514: DELETE FROM po_interface_errors
515: WHERE INTERFACE_TRANSACTION_ID in
516: (SELECT transaction_id
517: FROM po_requisitions_interface_all

Line 517: FROM po_requisitions_interface_all

513: -- Delete from the Errors table first so that the subquery can use po_requisitions_interface_all
514: DELETE FROM po_interface_errors
515: WHERE INTERFACE_TRANSACTION_ID in
516: (SELECT transaction_id
517: FROM po_requisitions_interface_all
518: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
519: AND INTERFACE_SOURCE_LINE_ID = l_po_header.OSP_ORDER_ID);
520: DELETE FROM po_requisitions_interface_all
521: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME

Line 520: DELETE FROM po_requisitions_interface_all

516: (SELECT transaction_id
517: FROM po_requisitions_interface_all
518: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
519: AND INTERFACE_SOURCE_LINE_ID = l_po_header.OSP_ORDER_ID);
520: DELETE FROM po_requisitions_interface_all
521: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
522: AND INTERFACE_SOURCE_LINE_ID = l_po_header.OSP_ORDER_ID;
523: END IF;
524: -- End Changes by jaramana on January 7, 2008 for the Requisition ER 6034236