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 1306: po_lines_all pol

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

Line 1989: po_lines pol

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

Line 2223: po_lines pol

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

Line 2457: po_lines pol

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

Line 2678: po_lines pol

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

Line 2876: po_lines pol

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

Line 3070: po_lines pol

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

Line 3945: po_lines pol

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