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_REQUISITION_LINES_ALL

Line 2757: po_requisition_lines_all porl,

2753: -- curosr to get the ReqHeaderId
2754: cursor c_getReqHdrId(p_po_header_id_csr IN NUMBER) is
2755: select distinct porh.requisition_header_id
2756: from po_requisition_headers_all porh,
2757: po_requisition_lines_all porl,
2758: po_headers_all poh,
2759: po_line_locations_all poll
2760: where porh.requisition_header_id = porl.requisition_header_id AND
2761: porl.line_location_id = poll.line_location_id AND

Line 2768: po_requisition_lines_all porl,

2764:
2765: cursor c_getReqHdrId_r(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) is
2766: select distinct porh.requisition_header_id
2767: from po_requisition_headers_all porh,
2768: po_requisition_lines_all porl,
2769: po_headers_all poh,
2770: po_line_locations_all poll
2771: where porh.requisition_header_id = porl.requisition_header_id AND
2772: porl.line_location_id = poll.line_location_id AND

Line 2986: FROM po_requisition_lines_all porl, --

2982: -- Cursor for Checking for the multipe backing reqs is mapped to the PO
2983:
2984: CURSOR c_reqs_count(p_po_header_id_csr IN NUMBER) is
2985: SELECT count(distinct porl.requisition_header_id)
2986: FROM po_requisition_lines_all porl, --
2987: po_line_locations_all poll
2988: WHERE poll.line_location_id = porl.line_location_id AND
2989: NVL(poll.cancel_flag, 'N') = 'N' AND
2990: NVL(poll.CLOSEd_code, 'OPEN') <> 'FINALLY CLOSED' AND

Line 2998: FROM po_requisition_lines_all porl, --

2994: -- Cursor for Checking for the multipe backing reqs is mapped to the releases
2995:
2996: CURSOR c_reqs_count_rel(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) is
2997: SELECT count(distinct porl.requisition_header_id)
2998: FROM po_requisition_lines_all porl, --
2999: po_line_locations_all poll
3000: WHERE poll.line_location_id = porl.line_location_id AND
3001: NVL(poll.cancel_flag, 'N') = 'N' AND
3002: NVL(poll.CLOSEd_code, 'OPEN') <> 'FINALLY CLOSED' AND

Line 3015: FROM po_requisition_lines_all porla,

3011: SELECT count(1)
3012: FROM po_line_locations_all plla
3013: WHERE plla.po_header_id = p_po_header_id_csr
3014: AND plla.line_location_id NOT IN (SELECT plla2.line_location_id
3015: FROM po_requisition_lines_all porla,
3016: po_line_locations_all plla2
3017: WHERE plla2.po_header_id = p_po_header_id_csr
3018: AND porla.line_location_id = plla2.line_location_id);
3019:

Line 3028: FROM po_requisition_lines_all porla,

3024: FROM po_line_locations_all plla
3025: WHERE plla.po_header_id = p_po_header_id_csr
3026: AND plla.po_release_id = p_po_release_id_csr
3027: AND plla.line_location_id NOT IN ( SELECT plla2.line_location_id
3028: FROM po_requisition_lines_all porla,
3029: po_line_locations_all plla2
3030: WHERE plla2.po_header_id = p_po_header_id_csr
3031: AND plla2.po_release_id = p_po_release_id_csr
3032: AND porla.line_location_id = plla2.line_location_id);

Line 3040: po_requisition_lines_all porl1,

3036:
3037: cursor c_cat_price_change(p_po_header_id_csr IN NUMBER) is
3038: select count(1)
3039: from po_change_requests pcr,
3040: po_requisition_lines_all porl1,
3041: po_line_locations_all pll
3042: where pcr.document_header_id = p_po_header_id_csr
3043: AND pcr.REQUEST_LEVEL = 'LINE'
3044: AND pcr.new_price is not NULL

Line 3055: po_requisition_lines_all porl1,

3051: -- Curosr for getting the Releases Price changes for Catlog request should go to the buyer
3052: cursor c_ship_price_change(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) is
3053: select count(1)
3054: from po_change_requests pcr,
3055: po_requisition_lines_all porl1,
3056: po_line_locations_all pll
3057: where pcr.document_header_id = p_po_header_id_csr
3058: AND pcr.po_release_id = p_po_release_id_csr
3059: AND pcr.REQUEST_LEVEL = 'SHIPMENT'

Line 3070: po_requisition_lines_all porl1,

3066: -- Cursor for checking the FPS price changes for catalog requests
3067: cursor c_fps_price_change(p_po_header_id_csr IN NUMBER) IS
3068: select count(1)
3069: from po_change_requests pcr,
3070: po_requisition_lines_all porl1,
3071: po_line_locations_all pll
3072: where pcr.document_header_id = p_po_header_id_csr
3073: AND pcr.REQUEST_LEVEL = 'SHIPMENT'
3074: AND pcr.new_amount is not NULL

Line 3086: po_requisition_lines_all porl,

3082:
3083: cursor c_req_locks(p_po_header_id_csr IN NUMBER) is
3084: select count(1)
3085: from po_requisition_headers_all porh,
3086: po_requisition_lines_all porl,
3087: po_headers_all poh,
3088: po_line_locations_all poll
3089: where porh.requisition_header_id = porl.requisition_header_id AND
3090: porl.line_location_id = poll.line_location_id AND

Line 3101: po_requisition_lines_all porl,

3097:
3098: cursor c_req_locks_rel(p_po_header_id_csr IN NUMBER, p_po_release_id_csr IN NUMBER) is
3099: select count(1)
3100: from po_requisition_headers_all porh,
3101: po_requisition_lines_all porl,
3102: po_headers_all poh,
3103: po_line_locations_all poll
3104: where porh.requisition_header_id = porl.requisition_header_id AND
3105: porl.line_location_id = poll.line_location_id AND

Line 3898: po_requisition_lines_all prla,

3894: prla.requisition_header_id,
3895: prla.line_location_id,
3896: prda.distribution_id
3897: FROM po_change_requests pcr,
3898: po_requisition_lines_all prla,
3899: po_req_distributions_all prda,
3900: po_line_locations_all plla
3901: WHERE document_header_id= p_po_header_id_csr
3902: AND request_status='BUYER_APP'

Line 3934: po_requisition_lines_all prla

3930: prla.line_location_id,
3931: null distribution_id
3932: FROM po_change_requests pcr,
3933: po_line_locations_all plla,
3934: po_requisition_lines_all prla
3935: WHERE document_header_id=p_po_header_id_csr
3936: AND request_status='BUYER_APP'
3937: AND change_active_flag='Y'
3938: AND initiator='SUPPLIER'

Line 3962: po_requisition_lines_all prla,

3958: prla.requisition_header_id,
3959: prla.line_location_id,
3960: prda.distribution_id
3961: FROM po_change_requests pcr,
3962: po_requisition_lines_all prla,
3963: po_req_distributions_all prda,
3964: po_line_locations_all plla
3965: WHERE pcr.po_release_id= p_po_release_id_csr
3966: AND request_status='BUYER_APP'

Line 3999: po_requisition_lines_all prla

3995: prla.line_location_id,
3996: null distribution_id
3997: FROM po_change_requests pcr,
3998: po_line_locations_all plla,
3999: po_requisition_lines_all prla
4000: WHERE pcr.po_release_id=p_po_release_id_csr
4001: AND request_status='BUYER_APP'
4002: AND change_active_flag='Y'
4003: AND initiator='SUPPLIER'

Line 4022: l_requisition_line_id po_requisition_lines_all.requisition_line_id%type ;

4018: l_request_level po_change_requests.request_level%type ;
4019: l_new_promised_date po_change_requests.new_promised_date%type ;
4020: l_new_need_by_date po_change_requests.new_need_by_date%type ;
4021: l_request_reason po_change_requests.request_reason%type ;
4022: l_requisition_line_id po_requisition_lines_all.requisition_line_id%type ;
4023: l_requisition_header_id po_requisition_lines_all.requisition_header_id%type ;
4024: l_line_location_id po_requisition_lines_all.line_location_id%type ;
4025: l_req_distribution_id po_req_distributions_all.distribution_id%type ;
4026: l_change_table PO_REQ_CHANGE_TABLE;

Line 4023: l_requisition_header_id po_requisition_lines_all.requisition_header_id%type ;

4019: l_new_promised_date po_change_requests.new_promised_date%type ;
4020: l_new_need_by_date po_change_requests.new_need_by_date%type ;
4021: l_request_reason po_change_requests.request_reason%type ;
4022: l_requisition_line_id po_requisition_lines_all.requisition_line_id%type ;
4023: l_requisition_header_id po_requisition_lines_all.requisition_header_id%type ;
4024: l_line_location_id po_requisition_lines_all.line_location_id%type ;
4025: l_req_distribution_id po_req_distributions_all.distribution_id%type ;
4026: l_change_table PO_REQ_CHANGE_TABLE;
4027: l_cancel_table PO_REQ_CANCEL_TABLE:=null;

Line 4024: l_line_location_id po_requisition_lines_all.line_location_id%type ;

4020: l_new_need_by_date po_change_requests.new_need_by_date%type ;
4021: l_request_reason po_change_requests.request_reason%type ;
4022: l_requisition_line_id po_requisition_lines_all.requisition_line_id%type ;
4023: l_requisition_header_id po_requisition_lines_all.requisition_header_id%type ;
4024: l_line_location_id po_requisition_lines_all.line_location_id%type ;
4025: l_req_distribution_id po_req_distributions_all.distribution_id%type ;
4026: l_change_table PO_REQ_CHANGE_TABLE;
4027: l_cancel_table PO_REQ_CANCEL_TABLE:=null;
4028: l_rec_count number :=0;

Line 4350: po_requisition_lines_all porl,

4346: CURSOR l_planners_csr(c_po_header_id IN NUMBER)
4347: IS
4348: select porh.PREPARER_ID
4349: from po_requisition_headers_all porh,
4350: po_requisition_lines_all porl,
4351: po_headers_all poh,
4352: po_line_locations_all poll
4353: where porh.requisition_header_id = porl.requisition_header_id AND
4354: porl.line_location_id = poll.line_location_id AND