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_REQCHANGEREQUESTWF_PVT dependencies on PO_RELEASES_ALL

Line 574: from po_releases_all

570: where po_header_id=p_po_header_id;
571: else
572: select nvl(authorization_status, 'IN PROCESS')
573: into l_doc_status
574: from po_releases_all
575: where po_release_id=p_po_release_id;
576: end if;
577:
578: x_progress :='PO_ReqChangeRequestWF_PVT.ValidateAndSaveRequest:001';

Line 1129: po_releases_all por

1125: po_headers_all poh,
1126: po_lines_all pol,
1127: po_line_locations_all pll,
1128: po_distributions_all pod,
1129: po_releases_all por
1130: where pcr.change_request_group_id=p_change_request_group_id
1131: and pcr.request_status='PENDING'
1132: and pcr.parent_change_request_id is not null
1133: and pcr.document_header_id=poh.po_header_id

Line 1382: from po_releases_all

1378: x_progress :='002';
1379: else
1380: select nvl(authorization_status, 'IN PROCESS'), revision_num
1381: into l_doc_status, ll_document_revision_num
1382: from po_releases_all
1383: where po_release_id=ll_po_release_id;
1384: x_progress :='003';
1385: end if;
1386:

Line 1888: update po_releases_all

1884: else
1885: l_document_subtype := 'BLANKET';
1886: l_document_type:= 'RELEASE';
1887:
1888: update po_releases_all
1889: set AUTHORIZATION_STATUS = 'APPROVED',
1890: approved_flag='Y',
1891: CHANGE_REQUESTED_BY=null,
1892: last_updated_by = fnd_global.user_id,

Line 2028: update po_releases_all set

2024: else
2025: -- fix bug 2733373. when change is submitted, and wait
2026: -- for buyer's response, we just set the status to
2027: -- 'IN PROCESS', but not the approved_flag
2028: update po_releases_all set
2029: AUTHORIZATION_STATUS = 'IN PROCESS',
2030: -- approved_flag='N',
2031: CHANGE_REQUESTED_BY='REQUESTER',
2032: last_updated_by = fnd_global.user_id,

Line 2971: po_releases_all por,

2967: from po_change_requests pcr,
2968: po_line_locations_all pll,
2969: po_requisition_lines_all prl,
2970: po_headers_all poh,
2971: po_releases_all por,
2972: po_lines_all pol
2973: where pcr.change_request_group_id=l_change_request_group_id
2974: and pcr.request_status='MGR_APP'
2975: and pcr.document_distribution_id is null

Line 3026: po_releases_all por,

3022: from po_change_requests pcr,
3023: po_line_locations_all pll,
3024: po_requisition_lines_all prl,
3025: po_headers_all poh,
3026: po_releases_all por,
3027: po_lines_all pol
3028: where pcr.change_request_group_id=l_change_request_group_id
3029: and pcr.request_status='MGR_APP'
3030: and pcr.document_distribution_id is null

Line 3081: po_releases_all por,

3077: from po_change_requests pcr,
3078: po_line_locations_all pll,
3079: po_requisition_lines_all prl,
3080: po_headers_all poh,
3081: po_releases_all por,
3082: po_distributions_all pod,
3083: po_req_distributions_all prd,
3084: po_lines_all pol
3085: where pcr.change_request_group_id=l_change_request_group_id

Line 3714: from PO_RELEASES_ALL

3710: x_progress := '004';
3711:
3712: select revision_num
3713: into l_revision_num
3714: from PO_RELEASES_ALL
3715: where po_release_id = p_doc_id;
3716:
3717: END IF;
3718:

Line 3963: update po_releases_all set

3959:
3960: -- fix bug 2733373. when change is submitted, and wait
3961: -- for buyer's response, we just set the status to
3962: -- 'IN PROCESS', but not the approved_flag
3963: update po_releases_all set
3964: AUTHORIZATION_STATUS = 'IN PROCESS',
3965: -- approved_flag='N',
3966: CHANGE_REQUESTED_BY='REQUESTER',
3967: last_updated_by = fnd_global.user_id,

Line 4396: from po_releases_all por, po_headers_all poh

4392: l_document_type_disp := fnd_message.get;
4393:
4394: select por.org_id, por.agent_id, poh.segment1||'-'||to_char(por.release_num)
4395: into l_org_id, l_agent_id, l_document_num
4396: from po_releases_all por, po_headers_all poh
4397: where por.po_release_id=l_document_id
4398: and por.po_header_id=poh.po_header_id;
4399: else
4400: l_document_subtype:='STANDARD';

Line 4709: update po_releases_all

4705: last_update_login = fnd_global.login_id,
4706: last_update_date = sysdate
4707: where po_header_id = p_document_id;
4708: else
4709: update po_releases_all
4710: set change_requested_by = null,
4711: last_updated_by = fnd_global.user_id,
4712: last_update_login = fnd_global.login_id,
4713: last_update_date = sysdate

Line 5007: from po_releases_all

5003: where requisition_header_id=l_doc_id;
5004: else
5005: select agent_id
5006: into l_employee_id
5007: from po_releases_all
5008: where po_release_id=l_doc_id;
5009: end if;
5010: end if;
5011:

Line 6445: from po_releases_all

6441: ELSIF l_doc_type = 'RELEASE' THEN
6442:
6443: select AUTHORIZATION_STATUS
6444: into l_authorization_status
6445: from po_releases_all
6446: where PO_RELEASE_ID = l_doc_id;
6447: end if;
6448:
6449:

Line 6625: from po_releases_all

6621: where po_header_id=l_doc_id;
6622: ELSIF l_doc_type = 'RELEASE' THEN
6623: select revision_num
6624: into l_doc_revision
6625: from po_releases_all
6626: where po_release_id=l_doc_id;
6627: end if;
6628:
6629: if(nvl(l_old_doc_revision, -1)=nvl(l_doc_revision, -1)) then

Line 6976: from po_releases_all

6972: ELSIF l_doc_type = 'RELEASE' THEN
6973:
6974: select agent_id
6975: into l_employee_id
6976: from po_releases_all
6977: where PO_RELEASE_ID = l_doc_id;
6978: end if;
6979:
6980:

Line 7461: UPDATE po_releases_all

7457: close document_id_rejected;
7458: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Poapprv_WF:05';
7459:
7460: IF(l_release_id is not null) THEN
7461: UPDATE po_releases_all
7462: SET authorization_status='APPROVED'
7463: WHERE po_release_id = l_release_id;
7464: ELSE
7465: UPDATE po_headers_all

Line 9624: from po_releases_all pr, po_headers_all ph

9620: ELSIF l_doc_type = 'RELEASE' THEN
9621:
9622: select pr.creation_date, ph.currency_code
9623: into l_order_date, l_po_currency
9624: from po_releases_all pr, po_headers_all ph
9625: where pr.po_release_id = l_doc_id
9626: and pr.po_header_id = ph.po_header_id;
9627:
9628: END IF;

Line 9980: po_releases_all por,

9976:
9977: SELECT por.document_creation_method, por.org_id
9978: INTO l_creation_method, l_po_org_id
9979: FROM
9980: po_releases_all por,
9981: po_change_requests pcr
9982: WHERE por.po_release_id = pcr.po_release_id
9983: AND pcr.change_request_group_id = l_po_chg_group_id
9984: AND rownum = 1;

Line 10185: FROM po_releases_all

10181: ELSIF l_document_type = 'RELEASE' THEN
10182:
10183: SELECT agent_id, creation_date
10184: INTO l_buyer_id, l_order_date
10185: FROM po_releases_all
10186: WHERE PO_RELEASE_ID = l_document_id;
10187:
10188: END IF;
10189:

Line 10328: FROM po_releases_all pr, po_headers_all ph

10324: ELSIF l_po_doc_type = 'RELEASE' THEN
10325:
10326: SELECT ph.currency_code
10327: INTO l_po_currency
10328: FROM po_releases_all pr, po_headers_all ph
10329: WHERE pr.po_release_id = l_po_doc_id
10330: and pr.po_header_id = ph.po_header_id;
10331:
10332: END IF;

Line 10818: from po_headers_all poh, po_releases_all pr

10814: -- For releases, the current doc header id is the release id
10815: if (l_po_doc_type = 'RELEASE') then
10816: select poh.currency_code, poh.org_id
10817: into l_po_currency_code, l_org_id
10818: from po_headers_all poh, po_releases_all pr
10819: where pr.po_release_id = l_poheader_id
10820: and poh.po_header_id = pr.po_header_id;
10821: else
10822: select poh.currency_code, poh.org_id