APPS.INV_UI_RCV_LOVS dependencies on PO_RELEASES_ALL

Line 323: from po_releases_all pr

319: OPEN x_po_release_num_lov FOR
320: select distinct pr.release_num
321: , pr.po_release_id
322: , pr.release_date
323: from po_releases_all pr
324: where pr.po_header_id = p_po_header_id
325: --AND pr.org_id = p_organization_id
326: and nvl(pr.cancel_flag, 'N') = 'N'
327: and nvl(pr.approved_flag, 'N') <> 'N'

Line 359: , po_releases_all pr

355: select distinct pr.release_num
356: , pr.po_release_id
357: , pr.release_date
358: from rcv_supply rsup
359: , po_releases_all pr
360: where rsup.po_header_id = p_po_header_id
361: --AND pr.org_id = p_organization_id
362: and nvl(pr.cancel_flag, 'N') = 'N'
363: and nvl(pr.approved_flag, 'N') <> 'N'

Line 3044: , po_releases_all prl

3040: , woov.repetitive_schedule_id
3041: FROM po_headers_all phl
3042: , po_lines_all pla
3043: , po_distributions_all pda
3044: , po_releases_all prl
3045: , wip_osp_jobs_val_v wojv
3046: , wip_osp_lines_val_v wolv
3047: , wip_osp_operations_val_v woov
3048: WHERE phl.po_header_id = p_po_header_id

Line 3130: from po_releases_all pr

3126: OPEN x_po_release_num_lov FOR
3127: select distinct pr.release_num
3128: , pr.po_release_id
3129: , pr.release_date
3130: from po_releases_all pr
3131: , po_line_locations_all pll
3132: , po_lines_all pl
3133: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3134: , mtl_parameters mp

Line 3164: , po_releases_all pr

3160: select distinct pr.release_num
3161: , pr.po_release_id
3162: , pr.release_date
3163: from rcv_supply rsup
3164: , po_releases_all pr
3165: where rsup.po_header_id = p_po_header_id
3166: --AND pr.org_id = p_organization_id
3167: and nvl(pr.cancel_flag, 'N') = 'N'
3168: and nvl(pr.approved_flag, 'N') <> 'N'