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 336: from sys.dual

332:
333: BEGIN
334: select 'Y'
335: into l_shipment_exist_flag
336: from sys.dual
337: where exists (
338: select 1
339: from PO_LINE_LOCATIONS_ALL
340: where po_header_id = p_po_header_id

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

772: /**
773: * Public function: Get_Shipment_Ack_Change_Status
774: * Requires: PO_HEADER_ID,PO_RELEASE_ID
775: * Modifies:
776: * Effects: Return the acknowledgement status of individual shipment.
777: * Possible values are:
778: * 1. ACK_REQUIRED
779: * 2. PENDING_CHANGE
780: * 3. PENDING_CANCEL

Line 1428: From sys.dual

1424: BEGIN
1425: If (p_po_release_id is not null) THEN
1426: Select 'A'
1427: into l_header_accepted_flag
1428: From sys.dual
1429: Where exists (
1430: select 1
1431: From PO_ACCEPTANCES
1432: Where po_release_id = p_po_release_id

Line 1440: From sys.dual

1436:
1437: ELSIF (p_po_header_id is not null) THEN
1438: Select 'A'
1439: into l_header_accepted_flag
1440: From sys.dual
1441: Where exists (
1442: select 'Y'
1443: From PO_ACCEPTANCES
1444: Where po_header_id = p_po_header_id

Line 1793: FROM sys.dual

1789: BEGIN
1790: IF (p_po_release_id is not null) THEN
1791: SELECT 'A'
1792: INTO l_header_accepted_flag
1793: FROM sys.dual
1794: WHERE exists (
1795: SELECT 1
1796: FROM PO_ACCEPTANCES
1797: WHERE po_release_id = p_po_release_id

Line 1805: FROM sys.dual

1801:
1802: ELSIF (p_po_header_id is not null) THEN
1803: SELECT 'A'
1804: INTO l_header_accepted_flag
1805: FROM sys.dual
1806: WHERE exists (
1807: SELECT 'Y'
1808: FROM PO_ACCEPTANCES
1809: WHERE po_header_id = p_po_header_id