[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
1419: prd.gl_encumbered_period_name,
1420: Nvl(prd.prevent_encumbrance_flag,'N'),
1421: prl.blanket_po_header_id
1422: FROM
1423: po_requisition_lines_all prl,
1424: po_req_distributions_all prd
1425: WHERE
1426: NVL(prl.closed_code, 'X') NOT IN ('CANCELLED','FINALLY CLOSED')
1427: AND NVL(prl.cancel_flag, 'N') = 'N'
1981: FROM
1982: fnd_currencies base_cur,
1983: gl_sets_of_books glsob,
1984: financials_system_parameters fsp,
1985: po_requisition_lines prl,
1986: po_req_distributions prd,
1987: po_requisition_headers prh,
1988: po_line_locations poll,
1989: po_distributions pod,
2215: FROM
2216: fnd_currencies base_cur,
2217: gl_sets_of_books glsob,
2218: financials_system_parameters fsp,
2219: po_requisition_lines prl,
2220: po_req_distributions prd,
2221: po_requisition_headers prh,
2222: po_line_locations poll,
2223: po_distributions pod,
2449: FROM
2450: fnd_currencies base_cur,
2451: gl_sets_of_books glsob,
2452: financials_system_parameters fsp,
2453: po_requisition_lines prl,
2454: po_req_distributions prd,
2455: po_requisition_headers prh,
2456: po_line_locations poll,
2457: po_distributions pod,
2670: FROM
2671: fnd_currencies base_cur,
2672: gl_sets_of_books glsob,
2673: financials_system_parameters fsp,
2674: po_requisition_lines prl,
2675: po_req_distributions prd,
2676: po_requisition_headers prh,
2677: po_line_locations poll,
2678: po_distributions pod,
3901: -- Removed the clause "AND ipe.exception_code = 'IGC_PO_YEP_PO_INV_STATE'"
3902: CURSOR c_get_po_errors(p_req_id NUMBER) IS
3903: SELECT 'x'
3904: FROM po_line_locations poll,
3905: po_requisition_lines porl,
3906: igc_cbc_po_process_excpts_all ipe
3907: WHERE porl.requisition_header_id = p_req_id
3908: AND porl.line_location_id = poll.line_location_id
3909: AND ipe.document_id = poll.po_header_id
3911:
3912: CURSOR c_get_po_future(p_req_id NUMBER) IS
3913: SELECT 'x'
3914: FROM po_distributions pod,
3915: po_requisition_lines porl,
3916: po_headers poh
3917: WHERE porl.requisition_header_id = p_req_id
3918: AND porl.line_location_id = pod.line_location_id
3919: AND pod.gl_encumbered_date >= p_curr_year_start_date
3951:
3952: CURSOR c_get_bpa_req_errs (p_bpa_header_id NUMBER) IS
3953: SELECT 'X'
3954: FROM igc_cbc_po_process_excpts_all ipe,
3955: po_requisition_lines prl
3956: WHERE prl.blanket_po_header_id = p_bpa_header_id
3957: AND prl.requisition_header_id = ipe.document_id
3958: AND ipe.document_type = 'REQ'
3959: AND ipe.conc_request_id = p_conc_request_id ;