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 2822: po_requisition_lines_all porl,

2818: -- curosr to get the ReqHeaderId
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

Line 2833: po_requisition_lines_all porl,

2829:
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

Line 3051: FROM po_requisition_lines_all porl, --

3047: -- Cursor for Checking for the multipe backing reqs is mapped to the PO
3048:
3049: CURSOR c_reqs_count(p_po_header_id_csr IN NUMBER) is
3050: SELECT count(distinct porl.requisition_header_id)
3051: FROM po_requisition_lines_all porl, --
3052: po_line_locations_all poll
3053: WHERE poll.line_location_id = porl.line_location_id AND
3054: NVL(poll.cancel_flag, 'N') = 'N' AND
3055: NVL(poll.CLOSEd_code, 'OPEN') <> 'FINALLY CLOSED' AND

Line 3063: FROM po_requisition_lines_all porl, --

3059: -- Cursor for Checking for the multipe backing reqs is mapped to the releases
3060:
3061: CURSOR c_reqs_count_rel(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) is
3062: SELECT count(distinct porl.requisition_header_id)
3063: FROM po_requisition_lines_all porl, --
3064: po_line_locations_all poll
3065: WHERE poll.line_location_id = porl.line_location_id AND
3066: NVL(poll.cancel_flag, 'N') = 'N' AND
3067: NVL(poll.CLOSEd_code, 'OPEN') <> 'FINALLY CLOSED' AND

Line 3080: FROM po_requisition_lines_all porla,

3076: SELECT count(1)
3077: FROM po_line_locations_all plla
3078: WHERE plla.po_header_id = p_po_header_id_csr
3079: AND plla.line_location_id NOT IN (SELECT plla2.line_location_id
3080: FROM po_requisition_lines_all porla,
3081: po_line_locations_all plla2
3082: WHERE plla2.po_header_id = p_po_header_id_csr
3083: AND porla.line_location_id = plla2.line_location_id);
3084:

Line 3093: FROM po_requisition_lines_all porla,

3089: FROM po_line_locations_all plla
3090: WHERE plla.po_header_id = p_po_header_id_csr
3091: AND plla.po_release_id = p_po_release_id_csr
3092: AND plla.line_location_id NOT IN ( SELECT plla2.line_location_id
3093: FROM po_requisition_lines_all porla,
3094: po_line_locations_all plla2
3095: WHERE plla2.po_header_id = p_po_header_id_csr
3096: AND plla2.po_release_id = p_po_release_id_csr
3097: AND porla.line_location_id = plla2.line_location_id);

Line 3105: po_requisition_lines_all porl1,

3101:
3102: cursor c_cat_price_change(p_po_header_id_csr IN NUMBER) is
3103: select count(1)
3104: from po_change_requests pcr,
3105: po_requisition_lines_all porl1,
3106: po_line_locations_all pll
3107: where pcr.document_header_id = p_po_header_id_csr
3108: AND pcr.REQUEST_LEVEL = 'LINE'
3109: AND pcr.new_price is not NULL

Line 3120: po_requisition_lines_all porl1,

3116: -- Curosr for getting the Releases Price changes for Catlog request should go to the buyer
3117: cursor c_ship_price_change(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) is
3118: select count(1)
3119: from po_change_requests pcr,
3120: po_requisition_lines_all porl1,
3121: po_line_locations_all pll
3122: where pcr.document_header_id = p_po_header_id_csr
3123: AND pcr.po_release_id = p_po_release_id_csr
3124: AND pcr.REQUEST_LEVEL = 'SHIPMENT'

Line 3135: po_requisition_lines_all porl1,

3131: -- Cursor for checking the FPS price changes for catalog requests
3132: cursor c_fps_price_change(p_po_header_id_csr IN NUMBER) IS
3133: select count(1)
3134: from po_change_requests pcr,
3135: po_requisition_lines_all porl1,
3136: po_line_locations_all pll
3137: where pcr.document_header_id = p_po_header_id_csr
3138: AND pcr.REQUEST_LEVEL = 'SHIPMENT'
3139: AND pcr.new_amount is not NULL

Line 3151: po_requisition_lines_all porl,

3147:
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

Line 3166: po_requisition_lines_all porl,

3162:
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

Line 4015: po_requisition_lines_all prla,

4011: prla.requisition_header_id,
4012: prla.line_location_id,
4013: prda.distribution_id
4014: FROM po_change_requests pcr,
4015: po_requisition_lines_all prla,
4016: po_req_distributions_all prda,
4017: po_line_locations_all plla
4018: WHERE document_header_id= p_po_header_id_csr
4019: AND request_status='BUYER_APP'

Line 4051: po_requisition_lines_all prla

4047: prla.line_location_id,
4048: null distribution_id
4049: FROM po_change_requests pcr,
4050: po_line_locations_all plla,
4051: po_requisition_lines_all prla
4052: WHERE document_header_id=p_po_header_id_csr
4053: AND request_status='BUYER_APP'
4054: AND change_active_flag='Y'
4055: AND initiator='SUPPLIER'

Line 4079: po_requisition_lines_all prla,

4075: prla.requisition_header_id,
4076: prla.line_location_id,
4077: prda.distribution_id
4078: FROM po_change_requests pcr,
4079: po_requisition_lines_all prla,
4080: po_req_distributions_all prda,
4081: po_line_locations_all plla
4082: WHERE pcr.po_release_id= p_po_release_id_csr
4083: AND request_status='BUYER_APP'

Line 4116: po_requisition_lines_all prla

4112: prla.line_location_id,
4113: null distribution_id
4114: FROM po_change_requests pcr,
4115: po_line_locations_all plla,
4116: po_requisition_lines_all prla
4117: WHERE pcr.po_release_id=p_po_release_id_csr
4118: AND request_status='BUYER_APP'
4119: AND change_active_flag='Y'
4120: AND initiator='SUPPLIER'

Line 4139: l_requisition_line_id po_requisition_lines_all.requisition_line_id%type ;

4135: l_request_level po_change_requests.request_level%type ;
4136: l_new_promised_date po_change_requests.new_promised_date%type ;
4137: l_new_need_by_date po_change_requests.new_need_by_date%type ;
4138: l_request_reason po_change_requests.request_reason%type ;
4139: l_requisition_line_id po_requisition_lines_all.requisition_line_id%type ;
4140: l_requisition_header_id po_requisition_lines_all.requisition_header_id%type ;
4141: l_line_location_id po_requisition_lines_all.line_location_id%type ;
4142: l_req_distribution_id po_req_distributions_all.distribution_id%type ;
4143: l_change_table PO_REQ_CHANGE_TABLE;

Line 4140: l_requisition_header_id po_requisition_lines_all.requisition_header_id%type ;

4136: l_new_promised_date po_change_requests.new_promised_date%type ;
4137: l_new_need_by_date po_change_requests.new_need_by_date%type ;
4138: l_request_reason po_change_requests.request_reason%type ;
4139: l_requisition_line_id po_requisition_lines_all.requisition_line_id%type ;
4140: l_requisition_header_id po_requisition_lines_all.requisition_header_id%type ;
4141: l_line_location_id po_requisition_lines_all.line_location_id%type ;
4142: l_req_distribution_id po_req_distributions_all.distribution_id%type ;
4143: l_change_table PO_REQ_CHANGE_TABLE;
4144: l_cancel_table PO_REQ_CANCEL_TABLE:=null;

Line 4141: l_line_location_id po_requisition_lines_all.line_location_id%type ;

4137: l_new_need_by_date po_change_requests.new_need_by_date%type ;
4138: l_request_reason po_change_requests.request_reason%type ;
4139: l_requisition_line_id po_requisition_lines_all.requisition_line_id%type ;
4140: l_requisition_header_id po_requisition_lines_all.requisition_header_id%type ;
4141: l_line_location_id po_requisition_lines_all.line_location_id%type ;
4142: l_req_distribution_id po_req_distributions_all.distribution_id%type ;
4143: l_change_table PO_REQ_CHANGE_TABLE;
4144: l_cancel_table PO_REQ_CANCEL_TABLE:=null;
4145: l_rec_count number :=0;

Line 4497: po_requisition_lines_all porl,

4493: CURSOR l_planners_csr(c_po_header_id IN NUMBER)
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