[Home] [Help]
137:
138: CURSOR c_lock_req IS
139: SELECT 'x'
140: FROM po_requisition_headers prh,
141: po_requisition_lines prl,
142: po_req_distributions prd
143: WHERE prh.requisition_header_id = p_document_id
144: AND prh.requisition_header_id = prl.requisition_header_id
145: AND prl.requisition_line_id = prd.requisition_line_id
1418: prd.gl_encumbered_period_name,
1419: Nvl(prd.prevent_encumbrance_flag,'N'),
1420: prl.blanket_po_header_id
1421: FROM
1422: po_requisition_lines_all prl,
1423: po_req_distributions_all prd
1424: WHERE
1425: NVL(prl.closed_code, 'X') NOT IN ('CANCELLED','FINALLY CLOSED')
1426: AND NVL(prl.cancel_flag, 'N') = 'N'
1980: FROM
1981: fnd_currencies base_cur,
1982: gl_sets_of_books glsob,
1983: financials_system_parameters fsp,
1984: po_requisition_lines prl,
1985: po_req_distributions prd,
1986: po_requisition_headers prh,
1987: po_line_locations poll,
1988: po_distributions pod,
2214: FROM
2215: fnd_currencies base_cur,
2216: gl_sets_of_books glsob,
2217: financials_system_parameters fsp,
2218: po_requisition_lines prl,
2219: po_req_distributions prd,
2220: po_requisition_headers prh,
2221: po_line_locations poll,
2222: po_distributions pod,
2448: FROM
2449: fnd_currencies base_cur,
2450: gl_sets_of_books glsob,
2451: financials_system_parameters fsp,
2452: po_requisition_lines prl,
2453: po_req_distributions prd,
2454: po_requisition_headers prh,
2455: po_line_locations poll,
2456: po_distributions pod,
2669: FROM
2670: fnd_currencies base_cur,
2671: gl_sets_of_books glsob,
2672: financials_system_parameters fsp,
2673: po_requisition_lines prl,
2674: po_req_distributions prd,
2675: po_requisition_headers prh,
2676: po_line_locations poll,
2677: po_distributions pod,
3900: -- Removed the clause "AND ipe.exception_code = 'IGC_PO_YEP_PO_INV_STATE'"
3901: CURSOR c_get_po_errors(p_req_id NUMBER) IS
3902: SELECT 'x'
3903: FROM po_line_locations poll,
3904: po_requisition_lines porl,
3905: igc_cbc_po_process_excpts_all ipe
3906: WHERE porl.requisition_header_id = p_req_id
3907: AND porl.line_location_id = poll.line_location_id
3908: AND ipe.document_id = poll.po_header_id
3910:
3911: CURSOR c_get_po_future(p_req_id NUMBER) IS
3912: SELECT 'x'
3913: FROM po_distributions pod,
3914: po_requisition_lines porl,
3915: po_headers poh
3916: WHERE porl.requisition_header_id = p_req_id
3917: AND porl.line_location_id = pod.line_location_id
3918: AND pod.gl_encumbered_date >= p_curr_year_start_date
3950:
3951: CURSOR c_get_bpa_req_errs (p_bpa_header_id NUMBER) IS
3952: SELECT 'X'
3953: FROM igc_cbc_po_process_excpts_all ipe,
3954: po_requisition_lines prl
3955: WHERE prl.blanket_po_header_id = p_bpa_header_id
3956: AND prl.requisition_header_id = ipe.document_id
3957: AND ipe.document_type = 'REQ'
3958: AND ipe.conc_request_id = p_conc_request_id ;