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_ACKNOWLEDGE_PO_PVT dependencies on DUAL

Line 323: from sys.dual

319:
320: BEGIN
321: select 'Y'
322: into l_shipment_exist_flag
323: from sys.dual
324: where exists (
325: select 1
326: from PO_LINE_LOCATIONS_ALL
327: where po_header_id = p_po_header_id

Line 763: * Effects: Return the acknowledgement status of individual shipment.

759: /**
760: * Public function: Get_Shipment_Ack_Change_Status
761: * Requires: PO_HEADER_ID,PO_RELEASE_ID
762: * Modifies:
763: * Effects: Return the acknowledgement status of individual shipment.
764: * Possible values are:
765: * 1. ACK_REQUIRED
766: * 2. PENDING_CHANGE
767: * 3. PENDING_CANCEL

Line 1415: From sys.dual

1411: BEGIN
1412: If (p_po_release_id is not null) THEN
1413: Select 'A'
1414: into l_header_accepted_flag
1415: From sys.dual
1416: Where exists (
1417: select 1
1418: From PO_ACCEPTANCES
1419: Where po_release_id = p_po_release_id

Line 1427: From sys.dual

1423:
1424: ELSIF (p_po_header_id is not null) THEN
1425: Select 'A'
1426: into l_header_accepted_flag
1427: From sys.dual
1428: Where exists (
1429: select 'Y'
1430: From PO_ACCEPTANCES
1431: Where po_header_id = p_po_header_id

Line 1780: FROM sys.dual

1776: BEGIN
1777: IF (p_po_release_id is not null) THEN
1778: SELECT 'A'
1779: INTO l_header_accepted_flag
1780: FROM sys.dual
1781: WHERE exists (
1782: SELECT 1
1783: FROM PO_ACCEPTANCES
1784: WHERE po_release_id = p_po_release_id

Line 1792: FROM sys.dual

1788:
1789: ELSIF (p_po_header_id is not null) THEN
1790: SELECT 'A'
1791: INTO l_header_accepted_flag
1792: FROM sys.dual
1793: WHERE exists (
1794: SELECT 'Y'
1795: FROM PO_ACCEPTANCES
1796: WHERE po_header_id = p_po_header_id