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 1306: po_line_locations_all poll,

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

Line 1988: po_line_locations poll,

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

Line 2222: po_line_locations poll,

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

Line 2456: po_line_locations poll,

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

Line 2677: po_line_locations poll,

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

Line 2873: po_line_locations poll,

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

Line 2874: po_line_locations prll,

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

Line 3067: po_line_locations poll,

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

Line 3068: po_line_locations prll,

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

Line 3904: FROM po_line_locations poll,

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