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.POS_SCO_TOLERANCE_PVT dependencies on PO_HEADERS_ALL

Line 44: FROM po_headers_all poha

40: WHERE change_request_group_id = p_change_request_grp_id_csr;
41:
42: CURSOR getDocSubType(p_po_header_id_csr IN NUMBER) IS
43: SELECT type_lookup_code
44: FROM po_headers_all poha
45: WHERE poha.po_header_id = p_po_header_id_csr;
46:
47: CURSOR getDocSubTypeRel(p_po_header_id_csr IN NUMBER, p_po_release_id_csr IN NUMBER) IS
48: SELECT distinct(release_type)

Line 55: FROM po_headers_all

51: AND pora.po_release_id = p_po_release_id_csr;
52:
53: CURSOR getOrgId(p_po_header_id_csr IN NUMBER) IS
54: SELECT org_id
55: FROM po_headers_all
56: WHERE po_header_id = p_po_header_id_csr;
57:
58: l_chg_req_grp_id po_change_requests.change_request_group_id%TYPE;
59: l_po_header_id po_headers_all.po_header_id%TYPE;

Line 59: l_po_header_id po_headers_all.po_header_id%TYPE;

55: FROM po_headers_all
56: WHERE po_header_id = p_po_header_id_csr;
57:
58: l_chg_req_grp_id po_change_requests.change_request_group_id%TYPE;
59: l_po_header_id po_headers_all.po_header_id%TYPE;
60: l_po_release_id po_releases_all.po_release_id%TYPE;
61: l_doc_type po_change_requests.document_type%TYPE;
62: l_po_style varchar2(10);
63: l_doc_subtype varchar2(10);

Line 508: l_po_header_id po_headers_all.po_header_id%type;

504: AND ( (pcr.new_promised_date <> old_promised_date) OR
505: (nvl(pcr.old_promised_date,nvl(pcr.old_need_by_date,pcr.new_promised_date - 1))<>pcr.new_promised_date)
506: );
507:
508: l_po_header_id po_headers_all.po_header_id%type;
509: l_change_group_id po_change_requests.change_request_group_id%type;
510: l_prom_date_dec NUMBER;
511: l_prom_date_incr NUMBER;
512: l_old_promise_date po_change_requests.old_promised_date%type;

Line 675: l_po_header_id po_headers_all.po_header_id%TYPE;

671:
672: -- cursor to check for the Complex Work( Actuals Case)
673:
674:
675: l_po_header_id po_headers_all.po_header_id%TYPE;
676: l_po_release_id po_releases_all.po_release_id%TYPE;
677: l_change_group_id po_change_requests.change_request_group_id%type;
678: l_unitprice_lower_tol number;
679: l_unitprice_upper_tol number;

Line 850: l_po_header_id po_headers_all.po_header_id%TYPE;

846: l_shipq_ty_max_dec_per NUMBER;
847: l_ship_qty_max_incr_val NUMBER;
848: l_ship_qty_max_dec_val NUMBER;
849: x_progress VARCHAR2(1000);
850: l_po_header_id po_headers_all.po_header_id%TYPE;
851: l_change_group_id po_change_requests.change_request_group_id%type;
852: l_po_style_type VARCHAR2(10);
853: l_doc_type VARCHAR2(10);
854:

Line 2532: l_po_header_id po_headers_all.po_header_id%TYPE;

2528: resultout OUT NOCOPY VARCHAR2)
2529:
2530: IS
2531: l_return_val VARCHAR2(1) ;
2532: l_po_header_id po_headers_all.po_header_id%TYPE;
2533: l_change_group_id po_change_requests.change_request_group_id%type;
2534: x_progress VARCHAR2(1000);
2535: l_po_style_type VARCHAR2(10);
2536: l_doc_type VARCHAR2(10);

Line 2823: po_headers_all poh,

2819: cursor c_getReqHdrId(p_po_header_id_csr IN NUMBER) is
2820: select distinct porh.requisition_header_id
2821: from po_requisition_headers_all porh,
2822: po_requisition_lines_all porl,
2823: po_headers_all poh,
2824: po_line_locations_all poll
2825: where porh.requisition_header_id = porl.requisition_header_id AND
2826: porl.line_location_id = poll.line_location_id AND
2827: poh.po_header_id = poll.po_header_id AND

Line 2834: po_headers_all poh,

2830: cursor c_getReqHdrId_r(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) is
2831: select distinct porh.requisition_header_id
2832: from po_requisition_headers_all porh,
2833: po_requisition_lines_all porl,
2834: po_headers_all poh,
2835: po_line_locations_all poll
2836: where porh.requisition_header_id = porl.requisition_header_id AND
2837: porl.line_location_id = poll.line_location_id AND
2838: poh.po_header_id = poll.po_header_id AND

Line 2842: l_po_header_id po_headers_all.po_header_id%TYPE;

2838: poh.po_header_id = poll.po_header_id AND
2839: poh.po_header_id = p_po_header_id_csr AND
2840: poll.po_release_id = p_po_release_id_csr;
2841:
2842: l_po_header_id po_headers_all.po_header_id%TYPE;
2843: l_po_release_id po_releases_all.po_release_id%TYPE;
2844: l_doc_type VARCHAR2(10);
2845: l_return_val VARCHAR2(1);
2846: l_change_group_id po_change_requests.change_request_group_id%TYPE;

Line 2964: l_po_header_id po_headers_all.po_header_id%TYPE;

2960: resultout OUT NOCOPY VARCHAR2)
2961:
2962: IS
2963:
2964: l_po_header_id po_headers_all.po_header_id%TYPE;
2965: l_po_release_id po_releases_all.po_release_id%TYPE;
2966: l_return_val VARCHAR2(1);
2967: x_progress VARCHAR2(1000);
2968: l_po_style_type VARCHAR2(10);

Line 3152: po_headers_all poh,

3148: cursor c_req_locks(p_po_header_id_csr IN NUMBER) is
3149: select count(1)
3150: from po_requisition_headers_all porh,
3151: po_requisition_lines_all porl,
3152: po_headers_all poh,
3153: po_line_locations_all poll
3154: where porh.requisition_header_id = porl.requisition_header_id AND
3155: porl.line_location_id = poll.line_location_id AND
3156: poh.po_header_id = poll.po_header_id AND

Line 3167: po_headers_all poh,

3163: cursor c_req_locks_rel(p_po_header_id_csr IN NUMBER, p_po_release_id_csr IN NUMBER) is
3164: select count(1)
3165: from po_requisition_headers_all porh,
3166: po_requisition_lines_all porl,
3167: po_headers_all poh,
3168: po_line_locations_all poll
3169: where porh.requisition_header_id = porl.requisition_header_id AND
3170: porl.line_location_id = poll.line_location_id AND
3171: poh.po_header_id = poll.po_header_id AND

Line 3480: FROM po_headers_all

3476: -- SCO created during Acknowledgement AND the supplier has rejected at least one shipment
3477: -- Cursor for checking whether sco is created during Acknowledgement or not.
3478: cursor c_sco_ack_ship(p_po_header_id_csr IN NUMBER) is
3479: SELECT acceptance_required_flag,revision_num
3480: FROM po_headers_all
3481: WHERE po_header_id = p_po_header_id_csr;
3482:
3483: -- Cursor for checking the acknowledgement status of the shipment
3484: cursor c_sco_ack_rej_ship(p_po_header_id_csr IN NUMBER, c_revision_num IN NUMBER) is

Line 3530: FROM po_headers_all

3526: -- Cursor for checking whether the signature is required or not
3527: /* 5550515
3528: cursor c_sgn_req_flag(p_po_header_id_csr IN NUMBER) IS
3529: SELECT acceptance_required_flag
3530: FROM po_headers_all
3531: WHERE po_header_id = p_po_header_id_csr;
3532: */
3533: cursor c_sgn_req_flag_po(p_po_header_id_csr IN NUMBER,c_revision_num IN NUMBER ) IS
3534: SELECT count(1)

Line 3563: l_accpt_req_flag po_headers_all.acceptance_required_flag%type;

3559: l_additional_change_requests number;
3560: l_ack_reject_cnt number;
3561: l_supp_item_chg_cnt number;
3562: l_temp number;
3563: l_accpt_req_flag po_headers_all.acceptance_required_flag%type;
3564: l_revision_num number;
3565: l_signature_required number :=0;
3566: l_ack_status_flag_count number;
3567: l_api_name varchar2(50) := 'AUTO_APP_BIZ_RULES';

Line 3775: l_po_header_id po_headers_all.po_header_id%TYPE;

3771: funcmode IN VARCHAR2,
3772: resultout OUT NOCOPY VARCHAR2)
3773: IS
3774:
3775: l_po_header_id po_headers_all.po_header_id%TYPE;
3776: x_progress VARCHAR2(1000);
3777: l_change_group_id po_change_requests.change_request_group_id%TYPE;
3778:
3779: BEGIN

Line 3952: l_po_header_id po_headers_all.po_header_id%type;

3948: funcmode IN VARCHAR2,
3949: resultout OUT NOCOPY VARCHAR2)
3950: IS
3951: l_change_group_id PO_CHANGE_REQUESTS.CHANGE_REQUEST_GROUP_ID%type;
3952: l_po_header_id po_headers_all.po_header_id%type;
3953: l_po_release_id po_releases_all.po_release_id%type;
3954: x_progress VARCHAR2(1000);
3955:
3956: BEGIN

Line 4498: po_headers_all poh,

4494: IS
4495: select UNIQUE(porh.PREPARER_ID)
4496: from po_requisition_headers_all porh,
4497: po_requisition_lines_all porl,
4498: po_headers_all poh,
4499: po_line_locations_all poll
4500: where porh.requisition_header_id = porl.requisition_header_id AND
4501: porl.line_location_id = poll.line_location_id AND
4502: poh.po_header_id = poll.po_header_id AND

Line 4531: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;

4527: l_requester_username fnd_user.user_name%type;
4528: l_requester_disp_name VARCHAR2(2000);
4529: l_requester_id number;
4530: l_planner_id number;
4531: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
4532: count_rec NUMBER;
4533: BEGIN
4534:
4535: x_progress :='MARK_SCO_FOR_REQ:000';