APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on PO_LINES

Line 152: po_lines pol ,

148: -- Amended Cursor below whilst testing Relock failure
149: CURSOR c_lock_po IS
150: SELECT 'x'
151: FROM po_headers poh,
152: po_lines pol ,
153: po_line_locations poll,
154: po_distributions pod
155: WHERE poh.po_header_id = p_document_id
156: AND poh.po_header_id = pol.po_header_id

Line 1307: po_lines_all pol

1303: pod.gl_encumbered_date,
1304: pod.gl_encumbered_period_name
1305: FROM po_distributions_all pod,
1306: po_line_locations_all poll,
1307: po_lines_all pol
1308: WHERE DECODE(poll.accrue_on_receipt_flag,
1309: 'N',
1310: NVL(pod.quantity_ordered,0) - GREATEST(NVL(pod.quantity_billed,0),
1311: NVL(pod.unencumbered_quantity,0)),

Line 1990: po_lines pol

1986: po_req_distributions prd,
1987: po_requisition_headers prh,
1988: po_line_locations poll,
1989: po_distributions pod,
1990: po_lines pol
1991: WHERE
1992: NVL(prl.closed_code,'OPEN') NOT IN ('CANCELLED','FINALLY CLOSED')
1993: AND NVL(prl.cancel_flag,'N') = 'N'
1994: AND NVL(prd.prevent_encumbrance_flag,'N') = 'N'

Line 2224: po_lines pol

2220: po_req_distributions prd,
2221: po_requisition_headers prh,
2222: po_line_locations poll,
2223: po_distributions pod,
2224: po_lines pol
2225: WHERE
2226: NVL(prl.closed_code,'OPEN') NOT IN ('CANCELLED','FINALLY CLOSED')
2227: AND NVL(prl.cancel_flag,'N') = 'N'
2228: AND NVL(prd.prevent_encumbrance_flag,'N') = 'N'

Line 2458: po_lines pol

2454: po_req_distributions prd,
2455: po_requisition_headers prh,
2456: po_line_locations poll,
2457: po_distributions pod,
2458: po_lines pol
2459: WHERE
2460: NVL(prl.closed_code,'OPEN') NOT IN ('CANCELLED','FINALLY CLOSED')
2461: AND NVL(prl.cancel_flag,'N') = 'N'
2462: AND NVL(prd.prevent_encumbrance_flag,'N') = 'N'

Line 2679: po_lines pol

2675: po_req_distributions prd,
2676: po_requisition_headers prh,
2677: po_line_locations poll,
2678: po_distributions pod,
2679: po_lines pol
2680: WHERE
2681: NVL(prl.closed_code,'OPEN') NOT IN ('CANCELLED','FINALLY CLOSED')
2682: AND NVL(prl.cancel_flag,'N') = 'N'
2683: AND NVL(prd.prevent_encumbrance_flag,'N') = 'N'

Line 2877: po_lines pol

2873: po_line_locations poll,
2874: po_line_locations prll,
2875: po_distributions pod,
2876: po_distributions prd,
2877: po_lines pol
2878: WHERE
2879: NVL(poll.closed_code,'OPEN') <> ('FINALLY CLOSED')
2880: AND NVL(poll.cancel_flag,'N') = 'N'
2881: AND poh.po_header_id = poll.po_header_id

Line 3071: po_lines pol

3067: po_line_locations poll,
3068: po_line_locations prll,
3069: po_distributions pod,
3070: po_distributions prd,
3071: po_lines pol
3072: WHERE
3073: NVL(poll.closed_code,'OPEN') <> ('FINALLY CLOSED')
3074: AND NVL(poll.cancel_flag,'N') = 'N'
3075: AND poh.po_header_id = poll.po_header_id

Line 3946: po_lines pol

3942: -- Added for PRC.FP.J, 3173178
3943: CURSOR c_get_bpa_po_errs (p_bpa_header_id NUMBER) IS
3944: SELECT 'X'
3945: FROM igc_cbc_po_process_excpts_all ipe,
3946: po_lines pol
3947: WHERE pol.from_header_id = p_bpa_header_id
3948: AND pol.po_header_id = ipe.document_id
3949: AND ipe.document_type = 'PO'
3950: AND ipe.conc_request_id = p_conc_request_id ;