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 PO_CHANGE_REQUESTS

Line 575: from PO_CHANGE_REQUESTS

571: l_return_status VARCHAR2(1) := null;
572:
573: CURSOR l_rel_supplier_cancel_csr IS
574: select 'Y'
575: from PO_CHANGE_REQUESTS
576: where po_release_id = p_po_release_id
577: and request_status = 'PENDING'
578: and request_level = 'HEADER'
579: and action_type = 'CANCELLATION'

Line 585: from PO_CHANGE_REQUESTS

581:
582:
583: CURSOR l_po_supplier_cancel_csr IS
584: select 'Y'
585: from PO_CHANGE_REQUESTS
586: where document_header_id = p_po_header_id
587: and request_status = 'PENDING'
588: and request_level = 'HEADER'
589: and action_type = 'CANCELLATION'

Line 785: l_action_type PO_CHANGE_REQUESTS.action_type%TYPE := null;

781:
782: l_ship_accepted_flag VARCHAR2(1) := null;
783: l_header_accepted_flag VARCHAR2(1) := null;
784: l_acceptance_required_flag VARCHAR2(1) := null;
785: l_action_type PO_CHANGE_REQUESTS.action_type%TYPE := null;
786:
787: l_revision_num NUMBER := p_revision_num;
788: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;
789:

Line 848: from PO_CHANGE_REQUESTS PCR,

844: IF (p_po_release_id is not null) THEN
845:
846: select PCR.action_type
847: into l_action_type
848: from PO_CHANGE_REQUESTS PCR,
849: PO_RELEASES_ALL POR
850: where pcr.document_line_location_id = P_line_location_id
851: and pcr.po_release_id = p_po_release_id
852: and por.po_release_id = p_po_release_id

Line 858: from po_change_requests pcr2

854: and request_level = 'SHIPMENT'
855: and ((request_status in ('PENDING', 'BUYER_APP', 'WAIT_MGR_APP','REQ_APP')) OR
856: (request_status = 'REJECTED' and change_request_group_id = (
857: select MAX(change_request_group_id)
858: from po_change_requests pcr2
859: where pcr2.po_release_id = p_po_release_id
860: and pcr2.request_status in ('PENDING', 'BUYER_APP', 'WAIT_MGR_APP'))) )
861: and rownum = 1;
862:

Line 867: from PO_CHANGE_REQUESTS PCR,

863: ELSIF (p_po_header_id is not null) THEN
864:
865: select PCR.action_type
866: into l_action_type
867: from PO_CHANGE_REQUESTS PCR,
868: PO_HEADERS_ALL POH
869: where pcr.document_line_location_id = P_line_location_id
870: and pcr.document_header_id = p_po_header_id
871: and poh.po_header_id = p_po_header_id

Line 877: from po_change_requests pcr2

873: and request_level = 'SHIPMENT'
874: and ((request_status in ('PENDING', 'BUYER_APP', 'WAIT_MGR_APP','REQ_APP')) OR
875: (request_status = 'REJECTED' and change_request_group_id = (
876: select MAX(change_request_group_id)
877: from po_change_requests pcr2
878: where pcr2.document_header_id = p_po_header_id
879: and pcr2.request_status in ('PENDING', 'BUYER_APP', 'WAIT_MGR_APP'))) )
880: and rownum = 1;
881:

Line 1179: from PO_CHANGE_REQUESTS PCR

1175:
1176: CURSOR c2_csr IS
1177: Select
1178: document_line_location_id
1179: from PO_CHANGE_REQUESTS PCR
1180: Where PCR.po_release_id = p_po_release_id
1181: And PCR.document_revision_num = p_revision_num - 1
1182: And PCR.document_line_location_id is not null
1183: And PCR.request_status = 'ACCEPTED'

Line 1217: from PO_CHANGE_REQUESTS PCR

1213:
1214: CURSOR c4_csr IS
1215: Select
1216: document_line_location_id
1217: from PO_CHANGE_REQUESTS PCR
1218: Where PCR.document_header_id = p_po_header_id
1219: And PCR.po_release_id is null
1220: And PCR.document_revision_num = p_revision_num - 1
1221: And PCR.document_line_location_id is not null

Line 1513: From PO_CHANGE_REQUESTS pcr, po_releases_all por

1509: And pa.revision_num = p_revision_num
1510: And pa.po_line_location_id = PLL.line_location_id )
1511: And not exists (
1512: select 1
1513: From PO_CHANGE_REQUESTS pcr, po_releases_all por
1514: WHERE por.po_release_id = p_po_release_id
1515: and por.change_requested_by = 'SUPPLIER'
1516: and pcr.po_release_id = p_po_release_id
1517: AND PCR.document_revision_num = p_revision_num

Line 1525: from po_change_requests pcr2

1521: And ((pcr.request_status in ('PENDING', 'BUYER_APP', 'WAIT_MGR_APP','REQ_APP')) OR
1522: (pcr.request_status = 'REJECTED'
1523: and pcr.CHANGE_REQUEST_GROUP_ID = (
1524: select MAX(pcr2.CHANGE_REQUEST_GROUP_ID)
1525: from po_change_requests pcr2
1526: where pcr2.po_release_id = p_po_release_id
1527: and pcr2.document_revision_num = p_revision_num
1528: and pcr2.request_status in ('PENDING', 'BUYER_APP', 'WAIT_MGR_APP')) ) ) )
1529: And nvl(pll.cancel_flag, 'N') = 'N'

Line 1547: From PO_CHANGE_REQUESTS pcr, po_headers_all poh

1543: And pa.revision_num = p_revision_num
1544: And pa.po_line_location_id = PLL.line_location_id )
1545: And not exists (
1546: select 1
1547: From PO_CHANGE_REQUESTS pcr, po_headers_all poh
1548: WHERE poh.po_header_id = p_po_header_id
1549: and poh.change_requested_by = 'SUPPLIER'
1550: and pcr.document_header_id = p_po_header_id
1551: AND PCR.document_revision_num = p_revision_num

Line 1559: from po_change_requests pcr2

1555: And ((pcr.request_status in ('PENDING', 'BUYER_APP', 'WAIT_MGR_APP','REQ_APP')) OR
1556: (pcr.request_status = 'REJECTED'
1557: and pcr.CHANGE_REQUEST_GROUP_ID = (
1558: select MAX(pcr2.CHANGE_REQUEST_GROUP_ID)
1559: from po_change_requests pcr2
1560: where pcr2.document_header_id = p_po_header_id
1561: and pcr2.document_revision_num = p_revision_num
1562: and pcr2.request_status in ('PENDING', 'BUYER_APP', 'WAIT_MGR_APP'))) ))
1563: And nvl(pll.cancel_flag, 'N') = 'N'