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 588: from PO_CHANGE_REQUESTS

584: l_return_status VARCHAR2(1) := null;
585:
586: CURSOR l_rel_supplier_cancel_csr IS
587: select 'Y'
588: from PO_CHANGE_REQUESTS
589: where po_release_id = p_po_release_id
590: and request_status = 'PENDING'
591: and request_level = 'HEADER'
592: and action_type = 'CANCELLATION'

Line 598: from PO_CHANGE_REQUESTS

594:
595:
596: CURSOR l_po_supplier_cancel_csr IS
597: select 'Y'
598: from PO_CHANGE_REQUESTS
599: where document_header_id = p_po_header_id
600: and request_status = 'PENDING'
601: and request_level = 'HEADER'
602: and action_type = 'CANCELLATION'

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

794:
795: l_ship_accepted_flag VARCHAR2(1) := null;
796: l_header_accepted_flag VARCHAR2(1) := null;
797: l_acceptance_required_flag VARCHAR2(1) := null;
798: l_action_type PO_CHANGE_REQUESTS.action_type%TYPE := null;
799:
800: l_revision_num NUMBER := p_revision_num;
801: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;
802:

Line 861: from PO_CHANGE_REQUESTS PCR,

857: IF (p_po_release_id is not null) THEN
858:
859: select PCR.action_type
860: into l_action_type
861: from PO_CHANGE_REQUESTS PCR,
862: PO_RELEASES_ALL POR
863: where pcr.document_line_location_id = P_line_location_id
864: and pcr.po_release_id = p_po_release_id
865: and por.po_release_id = p_po_release_id

Line 871: from po_change_requests pcr2

867: and request_level = 'SHIPMENT'
868: and ((request_status in ('PENDING', 'BUYER_APP', 'WAIT_MGR_APP','REQ_APP')) OR
869: (request_status = 'REJECTED' and change_request_group_id = (
870: select MAX(change_request_group_id)
871: from po_change_requests pcr2
872: where pcr2.po_release_id = p_po_release_id
873: and pcr2.request_status in ('PENDING', 'BUYER_APP', 'WAIT_MGR_APP'))) )
874: and rownum = 1;
875:

Line 880: from PO_CHANGE_REQUESTS PCR,

876: ELSIF (p_po_header_id is not null) THEN
877:
878: select PCR.action_type
879: into l_action_type
880: from PO_CHANGE_REQUESTS PCR,
881: PO_HEADERS_ALL POH
882: where pcr.document_line_location_id = P_line_location_id
883: and pcr.document_header_id = p_po_header_id
884: and poh.po_header_id = p_po_header_id

Line 890: from po_change_requests pcr2

886: and request_level = 'SHIPMENT'
887: and ((request_status in ('PENDING', 'BUYER_APP', 'WAIT_MGR_APP','REQ_APP')) OR
888: (request_status = 'REJECTED' and change_request_group_id = (
889: select MAX(change_request_group_id)
890: from po_change_requests pcr2
891: where pcr2.document_header_id = p_po_header_id
892: and pcr2.request_status in ('PENDING', 'BUYER_APP', 'WAIT_MGR_APP'))) )
893: and rownum = 1;
894:

Line 1192: from PO_CHANGE_REQUESTS PCR

1188:
1189: CURSOR c2_csr IS
1190: Select
1191: document_line_location_id
1192: from PO_CHANGE_REQUESTS PCR
1193: Where PCR.po_release_id = p_po_release_id
1194: And PCR.document_revision_num = p_revision_num - 1
1195: And PCR.document_line_location_id is not null
1196: And PCR.request_status = 'ACCEPTED'

Line 1230: from PO_CHANGE_REQUESTS PCR

1226:
1227: CURSOR c4_csr IS
1228: Select
1229: document_line_location_id
1230: from PO_CHANGE_REQUESTS PCR
1231: Where PCR.document_header_id = p_po_header_id
1232: And PCR.po_release_id is null
1233: And PCR.document_revision_num = p_revision_num - 1
1234: And PCR.document_line_location_id is not null

Line 1526: From PO_CHANGE_REQUESTS pcr, po_releases_all por

1522: And pa.revision_num = p_revision_num
1523: And pa.po_line_location_id = PLL.line_location_id )
1524: And not exists (
1525: select 1
1526: From PO_CHANGE_REQUESTS pcr, po_releases_all por
1527: WHERE por.po_release_id = p_po_release_id
1528: and por.change_requested_by = 'SUPPLIER'
1529: and pcr.po_release_id = p_po_release_id
1530: AND PCR.document_revision_num = p_revision_num

Line 1538: from po_change_requests pcr2

1534: And ((pcr.request_status in ('PENDING', 'BUYER_APP', 'WAIT_MGR_APP','REQ_APP')) OR
1535: (pcr.request_status = 'REJECTED'
1536: and pcr.CHANGE_REQUEST_GROUP_ID = (
1537: select MAX(pcr2.CHANGE_REQUEST_GROUP_ID)
1538: from po_change_requests pcr2
1539: where pcr2.po_release_id = p_po_release_id
1540: and pcr2.document_revision_num = p_revision_num
1541: and pcr2.request_status in ('PENDING', 'BUYER_APP', 'WAIT_MGR_APP')) ) ) )
1542: And nvl(pll.cancel_flag, 'N') = 'N'

Line 1560: From PO_CHANGE_REQUESTS pcr, po_headers_all poh

1556: And pa.revision_num = p_revision_num
1557: And pa.po_line_location_id = PLL.line_location_id )
1558: And not exists (
1559: select 1
1560: From PO_CHANGE_REQUESTS pcr, po_headers_all poh
1561: WHERE poh.po_header_id = p_po_header_id
1562: and poh.change_requested_by = 'SUPPLIER'
1563: and pcr.document_header_id = p_po_header_id
1564: AND PCR.document_revision_num = p_revision_num

Line 1572: from po_change_requests pcr2

1568: And ((pcr.request_status in ('PENDING', 'BUYER_APP', 'WAIT_MGR_APP','REQ_APP')) OR
1569: (pcr.request_status = 'REJECTED'
1570: and pcr.CHANGE_REQUEST_GROUP_ID = (
1571: select MAX(pcr2.CHANGE_REQUEST_GROUP_ID)
1572: from po_change_requests pcr2
1573: where pcr2.document_header_id = p_po_header_id
1574: and pcr2.document_revision_num = p_revision_num
1575: and pcr2.request_status in ('PENDING', 'BUYER_APP', 'WAIT_MGR_APP'))) ))
1576: And nvl(pll.cancel_flag, 'N') = 'N'