APPS.INV_UI_RCV_LOVS dependencies on PO_RELEASES_ALL

Line 344: from po_releases_all pr

340: OPEN x_po_release_num_lov FOR
341: select distinct pr.release_num
342: , pr.po_release_id
343: , pr.release_date
344: from po_releases_all pr
345: where pr.po_header_id = p_po_header_id
346: --AND pr.org_id = p_organization_id
347: and nvl(pr.cancel_flag, 'N') = 'N'
348: and nvl(pr.approved_flag, 'N') <> 'N'

Line 380: , po_releases_all pr

376: select distinct pr.release_num
377: , pr.po_release_id
378: , pr.release_date
379: from rcv_supply rsup
380: , po_releases_all pr
381: where rsup.po_header_id = p_po_header_id
382: --AND pr.org_id = p_organization_id
383: and nvl(pr.cancel_flag, 'N') = 'N'
384: and nvl(pr.approved_flag, 'N') <> 'N'

Line 3120: , po_releases_all prl

3116: , woov.repetitive_schedule_id
3117: FROM po_headers_all phl
3118: , po_lines_all pla
3119: , po_distributions_all pda
3120: , po_releases_all prl
3121: , wip_osp_jobs_val_v wojv
3122: , wip_osp_lines_val_v wolv
3123: , wip_osp_operations_val_v woov
3124: WHERE phl.po_header_id = p_po_header_id

Line 3246: from po_releases_all pr

3242: OPEN x_po_release_num_lov FOR
3243: select distinct pr.release_num
3244: , pr.po_release_id
3245: , pr.release_date
3246: from po_releases_all pr
3247: , po_line_locations_all pll
3248: , po_lines_all pl
3249: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3250: , mtl_parameters mp

Line 3280: , po_releases_all pr

3276: select distinct pr.release_num
3277: , pr.po_release_id
3278: , pr.release_date
3279: from rcv_supply rsup
3280: , po_releases_all pr
3281: where rsup.po_header_id = p_po_header_id
3282: --AND pr.org_id = p_organization_id
3283: and nvl(pr.cancel_flag, 'N') = 'N'
3284: and nvl(pr.approved_flag, 'N') <> 'N'