[Home] [Help]
58: AND (mp.wms_enabled_flag = 'N' OR (mp.wms_enabled_flag = 'Y'
59: AND (plt.outside_operation_flag = 'Y'
60: OR pol.item_id is NULL
61: OR exists (SELECT 1
62: FROM mtl_system_items_kfv msik
63: WHERE msik.inventory_item_id = pol.item_id
64: AND msik.organization_id = p_organization_id
65: AND msik.mtl_transactions_enabled_flag = 'N'))))
66: AND poh.segment1 LIKE (p_po_number)
119: AND Item_Id IS NULL
120: )
121: OR EXISTS
122: (SELECT 1
123: FROM mtl_System_Items_kfv msik
124: WHERE msik.Inventory_Item_Id IN
125: (SELECT Item_Id
126: FROM po_Lines_All
127: WHERE po_Header_Id = poh.po_Header_Id
281: OR (mp.wms_enabled_flag = 'Y'
282: AND (plt.outside_operation_flag = 'Y'
283: OR pol.item_id is NULL
284: OR exists (SELECT 1
285: FROM mtl_system_items_kfv msik
286: WHERE msik.inventory_item_id = pol.item_id
287: AND msik.organization_id = p_organization_id
288: AND msik.mtl_transactions_enabled_flag = 'N'))))
289: -- END BUG 5166887
935: and rsl.shipment_header_id = rsh.shipment_header_id
936: and (mp.wms_enabled_flag = 'N'
937: OR (mp.wms_enabled_flag = 'Y' AND (rsl.item_id is NULL
938: OR exists (SELECT 1
939: FROM mtl_system_items_kfv msik
940: WHERE msik.inventory_item_id = rsl.item_id
941: AND msik.organization_id = p_organization_id
942: AND msik.mtl_transactions_enabled_flag = 'N')
943: OR exists
1106: AND (mp.wms_enabled_flag = 'N'
1107: OR (mp.wms_enabled_flag = 'Y'
1108: AND (rsl.item_id is NULL
1109: OR exists (SELECT 1
1110: FROM mtl_system_items_kfv msik
1111: WHERE msik.inventory_item_id = rsl.item_id
1112: AND msik.organization_id = p_organization_id
1113: AND msik.mtl_transactions_enabled_flag = 'N')
1114: OR exists (select '1'
1457: The following changes have been done while selecting Purchase Orders.
1458: i.e. doc type of PO.
1459: a. In the condition, "AND NVL(poll.approved_flag,'N') = 'Y' " ,
1460: nvl() has been removed.
1461: b. Removed the tables mtl_system_items_kfv and mtl_units_of_measure which are
1462: joined with po_lines_all table through outer join.
1463: c. Added the hint " +index(POH PO_HEADERS_U2) " to use the index PO_HEADERS_U2.
1464: d. Removed the Distinct clause from the select statement.
1465: */
1591: SELECT
1592: 'Valid PO Shipments'
1593: FROM po_lines_all pl ,
1594: mtl_related_items mri ,
1595: mtl_system_items_kfv msi ,
1596: po_line_locations_all poll
1597: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1598: , mtl_parameters mp,
1599: rcv_parameters rp
1724: FROM po_headers poh,
1725: fnd_lookup_values_vl flv ,
1726: po_lines_all pl ,
1727: mtl_related_items mri ,
1728: mtl_system_items_kfv msi ,
1729: po_line_locations_all poll
1730: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1731: , mtl_parameters mp,
1732: rcv_parameters rp
1786: FROM po_headers poh,
1787: fnd_lookup_values_vl flv ,
1788: po_lines_all pl ,
1789: mtl_related_items mri ,
1790: mtl_system_items_kfv msi ,
1791: po_line_locations_all poll
1792: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1793: , mtl_parameters mp,
1794: rcv_parameters rp
2476: SELECT
2477: 'Valid PO Shipments'
2478: FROM po_lines_all pl ,
2479: mtl_related_items mri ,
2480: mtl_system_items_kfv msi ,
2481: po_line_locations_all poll
2482: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
2483: , mtl_parameters mp,
2484: rcv_parameters rp
2884: WHEN OTHERS then
2885: po_line_number := p_po_line_num;
2886: END;
2887: IF p_mobile_form = 'RECEIPT' THEN
2888: /*Bug#5612236. In the below query, replaced 'MTL_SYSTEM_ITEMS_KFV' with
2889: 'MTL_SYSTEM_ITEMS_VL' and item desc is selected from this table.*/
2890: OPEN x_po_line_num_lov FOR
2891: -- Bug 6437363 : Modified the query for better performance.
2892: select distinct pl.line_num
3374: msi.stock_enabled_flag
3375: from po_lines_all pol
3376: ,mtl_related_items mri
3377: ,mtl_system_items_vl msi /* Bug 5581528 */
3378: /*,mtl_system_items_kfv msia */ /* Bug 6334679*/
3379: where msi.organization_id = p_organization_id
3380: and msi.concatenated_segments like p_concatenated_segments
3381: and pol.po_header_id = p_poHeaderID
3382: and pol.item_id = msi.inventory_item_id
3835: msi.stock_enabled_flag
3836: from po_lines_all pol
3837: ,mtl_related_items mri
3838: ,mtl_system_items_vl msi /* Bug 5581528 */
3839: /*,mtl_system_items_kfv msia */ /* Bug 6334679 */
3840: where msi.organization_id = p_organization_id
3841: and msi.concatenated_segments like p_concatenated_segments
3842: and pol.po_header_id = p_poHeaderID
3843: and pol.item_id = msi.inventory_item_id
4307: msi.stock_enabled_flag
4308: from po_lines_all pol
4309: ,mtl_related_items mri
4310: ,mtl_system_items_vl msi /* Bug 5581528 */
4311: /*,mtl_system_items_kfv msia */ /* Bug 6334679 */
4312: where msi.organization_id = p_organization_id
4313: and msi.concatenated_segments like p_concatenated_segments
4314: and pol.po_header_id = p_poHeaderID
4315: and pol.item_id = msi.inventory_item_id
4768: msi.stock_enabled_flag
4769: from po_lines_all pol
4770: ,mtl_related_items mri
4771: ,mtl_system_items_vl msi /* Bug 5581528 */
4772: /*,mtl_system_items_kfv msia */ /* Bug 6334679 */
4773: where msi.organization_id = p_organization_id
4774: and msi.concatenated_segments like p_concatenated_segments
4775: and pol.po_header_id = p_poHeaderID
4776: and pol.item_id = msi.inventory_item_id
5192: msi.stock_enabled_flag
5193: from po_lines_all pol
5194: ,mtl_related_items mri
5195: ,mtl_system_items_vl msi /* Bug 5581528 */
5196: /*,mtl_system_items_kfv msia*/ /* Bug 6334679 */
5197: where msi.organization_id = p_organization_id
5198: and msi.concatenated_segments like p_concatenated_segments
5199: and pol.po_header_id = p_poHeaderID
5200: and pol.item_id = msi.inventory_item_id
5611: msi.stock_enabled_flag
5612: from po_lines_all pol
5613: ,mtl_related_items mri
5614: ,mtl_system_items_vl msi /* Bug 5581528 */
5615: /*,mtl_system_items_kfv msia */ /* Bug 6334679 */
5616: where msi.organization_id = p_organization_id
5617: and msi.concatenated_segments like p_concatenated_segments
5618: and pol.po_header_id = p_poHeaderID
5619: and pol.item_id = msi.inventory_item_id