DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on PO_LINES_ALL

Line 62: , po_lines_all pol

58: , to_char(poh.org_id) --
59: FROM rcv_supply ms
60: , rcv_transactions rt
61: , po_headers_all poh
62: , po_lines_all pol
63: , po_line_types plt
64: , mtl_parameters mp
65: WHERE poh.po_header_id = ms.po_header_id
66: AND ms.quantity > 0

Line 95: /* Modified the above Query for Bug # 7113772. Removed the join from po_lines_all and po_line_types due to bad performance */

91: OR rt.routing_header_id IS NULL)
92: ORDER BY decode(rtrim(poh.segment1,'0123456789'),null,null,poh.segment1),
93: decode(rtrim(poh.segment1,'0123456789'),null,to_number(poh.segment1),null); -- */
94:
95: /* Modified the above Query for Bug # 7113772. Removed the join from po_lines_all and po_line_types due to bad performance */
96:
97: SELECT DISTINCT poh.Segment1 ,
98: poh.po_Header_Id ,
99: poh.Type_LookUp_Code ,

Line 975: , po_lines_all pol

971: AND msik.organization_id = p_organization_id
972: AND msik.mtl_transactions_enabled_flag = 'N')
973: OR exists
974: (select '1' from po_headers_all poh
975: , po_lines_all pol
976: , po_line_types plt
977: where rt.po_header_id is not null
978: and rt.po_header_id = poh.po_header_id
979: and poh.po_header_id = pol.po_header_id

Line 1148: , po_lines_all pol

1144: AND msik.organization_id = p_organization_id
1145: AND msik.mtl_transactions_enabled_flag = 'N')
1146: OR exists (select '1'
1147: from po_headers_all poh
1148: , po_lines_all pol
1149: , po_line_types plt
1150: where rt.po_header_id is not null
1151: and rt.po_header_id = poh.po_header_id
1152: and poh.po_header_id = pol.po_header_id

Line 1494: joined with po_lines_all table through outer join.

1490: i.e. doc type of PO.
1491: a. In the condition, "AND NVL(poll.approved_flag,'N') = 'Y' " ,
1492: nvl() has been removed.
1493: b. Removed the tables mtl_system_items_kfv and mtl_units_of_measure which are
1494: joined with po_lines_all table through outer join.
1495: c. Added the hint " +index(POH PO_HEADERS_U2) " to use the index PO_HEADERS_U2.
1496: d. Removed the Distinct clause from the select statement.
1497: */
1498:

Line 1681: -- Query needs to be driven from PO_LINES_ALL table. Here subquery

1677: -- and cross ref item case.
1678:
1679: -- Added the Hint /*+LEADING(PL)*/ as part of Fix for Bug 4638235
1680: -- incase Item ID is given and Doc No is not given.
1681: -- Query needs to be driven from PO_LINES_ALL table. Here subquery
1682: -- has been made as join.
1683: OPEN x_doc_num_lov FOR
1684: SELECT /*+LEADING(PL)*/
1685: -- DISTINCT

Line 2958: For this case,we have value if item_id in po_lines_all table as null,

2954: 'MTL_SYSTEM_ITEMS_VL' and item desc is selected from this table.*/
2955:
2956: /*Bug # 8687063 : Because of the fix done for bug 6437363, the query was returning
2957: zero row for expense item (We do not enter item while creating PO in this case).
2958: For this case,we have value if item_id in po_lines_all table as null,
2959: Modified the AND clasue in such a way that MSI should not be checked for organization_id
2960: if po_lines_all.item_id is null */
2961:
2962: OPEN x_po_line_num_lov FOR

Line 2960: if po_lines_all.item_id is null */

2956: /*Bug # 8687063 : Because of the fix done for bug 6437363, the query was returning
2957: zero row for expense item (We do not enter item while creating PO in this case).
2958: For this case,we have value if item_id in po_lines_all table as null,
2959: Modified the AND clasue in such a way that MSI should not be checked for organization_id
2960: if po_lines_all.item_id is null */
2961:
2962: OPEN x_po_line_num_lov FOR
2963: -- Bug 6437363 : Modified the query for better performance.
2964: select distinct pl.line_num

Line 3118: , po_lines_all pla

3114: , pda.po_distribution_id
3115: , (pda.quantity_ordered - pda.quantity_delivered)
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

Line 3158: , po_lines_all pla

3154: , pda.po_distribution_id
3155: , (pda.quantity_ordered - pda.quantity_delivered)
3156: , woov.repetitive_schedule_id
3157: FROM po_headers_all phl
3158: , po_lines_all pla
3159: , po_distributions_all pda
3160: , wip_osp_jobs_val_v wojv
3161: , wip_osp_lines_val_v wolv
3162: , wip_osp_operations_val_v woov

Line 3196: , po_lines_all pla

3192: , pda.po_distribution_id
3193: , (pda.quantity_ordered - pda.quantity_delivered)
3194: , woov.repetitive_schedule_id
3195: FROM po_headers_all phl
3196: , po_lines_all pla
3197: , po_distributions_all pda
3198: , wip_osp_jobs_val_v wojv
3199: , wip_osp_lines_val_v wolv
3200: , wip_osp_operations_val_v woov

Line 3248: , po_lines_all pl

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
3251: , rcv_parameters rp
3252: -- End for Bug 7440217

Line 3430: po_lines_all pol -- Bug 14645109 s added

3426: stock_enabled_flag,
3427: ' ',
3428: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
3429: from mtl_system_items_vl, /* Bug 5581528 */
3430: po_lines_all pol -- Bug 14645109 s added
3431: WHERE organization_id = p_Organization_Id
3432: and concatenated_segments like p_concatenated_segments||l_append
3433: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
3434: and inventory_item_id = pol.item_id -- Bug 14645109 s change this

Line 4007: po_lines_all pol -- Bug 14645109 s added

4003: stock_enabled_flag,
4004: ' ',
4005: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4006: from mtl_system_items_vl, /* Bug 5581528 */
4007: po_lines_all pol -- Bug 14645109 s added
4008: WHERE organization_id = p_Organization_Id
4009: and concatenated_segments like p_concatenated_segments||l_append
4010: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
4011: -- CLM project, bug 9403291

Line 4538: -- In the first query PO_LINES_ALL is

4534: else
4535: -- *****************************
4536: --- headerBased PJM Transaction
4537: -- Bug 4602289
4538: -- In the first query PO_LINES_ALL is
4539: -- joined to enforce a nested loop
4540: -- which would perform better for queries
4541: -- with/without item
4542: -- HeaderBased PJM PO_LINES_U2 is enforced

Line 4733: select /*+ INDEX(PO_LINES_ALL PO_LINES_U2) */ --bug 4602289

4729: UNION ALL
4730: -- Vendor Item SQL
4731: -- Bug# 6747729
4732: -- Added code to also fetch stock_enabled_flag from mtl_system_items_vl
4733: select /*+ INDEX(PO_LINES_ALL PO_LINES_U2) */ --bug 4602289
4734: distinct pol.vendor_product_num,
4735: msi.inventory_item_id,
4736: Nvl(pol.item_description, msi.description), -- Bug 14645109 s change this
4737: Nvl(msi.revision_qty_control_code,1),

Line 5169: po_lines_all pol -- Bug 14645109 s

5165: stock_enabled_flag,
5166: ' ',
5167: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5168: from mtl_system_items_vl, /* Bug 5581528 */
5169: po_lines_all pol -- Bug 14645109 s
5170: WHERE organization_id = p_Organization_Id
5171: and concatenated_segments like p_concatenated_segments||l_append
5172: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
5173: and inventory_item_id =pol.item_id --Bug 14645109 s changed from this part

Line 5698: po_lines_all pl -- Bug 14645109 s

5694: stock_enabled_flag,
5695: ' ',
5696: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5697: from mtl_system_items_vl , /* Bug 5581528 */
5698: po_lines_all pl -- Bug 14645109 s
5699: WHERE organization_id = p_Organization_Id
5700: and concatenated_segments like p_concatenated_segments||l_append
5701: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
5702: -- CLM project, bug 9403291