APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on PO_LINE_LOCATIONS

Line 153: po_line_locations poll,

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
157: AND pol.po_header_id = poll.po_header_id

Line 164: po_line_locations poll,

160:
161: CURSOR c_lock_release IS
162: SELECT 'x'
163: FROM po_releases por,
164: po_line_locations poll,
165: po_distributions pod
166: WHERE por.po_release_id = p_document_id
167: AND por.po_release_id = poll.po_release_id
168: AND poll.po_release_id = pod.po_release_id

Line 1305: po_line_locations_all poll,

1301: NVL(pod.encumbered_flag,'N'),
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),

Line 1987: po_line_locations poll,

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,
1989: po_lines pol
1990: WHERE
1991: NVL(prl.closed_code,'OPEN') NOT IN ('CANCELLED','FINALLY CLOSED')

Line 2221: po_line_locations poll,

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,
2223: po_lines pol
2224: WHERE
2225: NVL(prl.closed_code,'OPEN') NOT IN ('CANCELLED','FINALLY CLOSED')

Line 2455: po_line_locations poll,

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,
2457: po_lines pol
2458: WHERE
2459: NVL(prl.closed_code,'OPEN') NOT IN ('CANCELLED','FINALLY CLOSED')

Line 2676: po_line_locations poll,

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,
2678: po_lines pol
2679: WHERE
2680: NVL(prl.closed_code,'OPEN') NOT IN ('CANCELLED','FINALLY CLOSED')

Line 2872: po_line_locations poll,

2868: fnd_currencies base_cur,
2869: gl_sets_of_books glsob,
2870: financials_system_parameters fsp,
2871: po_headers poh,
2872: po_line_locations poll,
2873: po_line_locations prll,
2874: po_distributions pod,
2875: po_distributions prd,
2876: po_lines pol

Line 2873: po_line_locations prll,

2869: gl_sets_of_books glsob,
2870: financials_system_parameters fsp,
2871: po_headers poh,
2872: po_line_locations poll,
2873: po_line_locations prll,
2874: po_distributions pod,
2875: po_distributions prd,
2876: po_lines pol
2877: WHERE

Line 3066: po_line_locations poll,

3062: fnd_currencies base_cur,
3063: gl_sets_of_books glsob,
3064: financials_system_parameters fsp,
3065: po_headers poh,
3066: po_line_locations poll,
3067: po_line_locations prll,
3068: po_distributions pod,
3069: po_distributions prd,
3070: po_lines pol

Line 3067: po_line_locations prll,

3063: gl_sets_of_books glsob,
3064: financials_system_parameters fsp,
3065: po_headers poh,
3066: po_line_locations poll,
3067: po_line_locations prll,
3068: po_distributions pod,
3069: po_distributions prd,
3070: po_lines pol
3071: WHERE

Line 3903: FROM po_line_locations poll,

3899: -- Bug 2803967,
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