[Home] [Help]
1626: (
1627: SELECT
1628: 'Valid PO Shipments'
1629: FROM po_lines_trx_v pl , -- CLM project, bug 9403291
1630: mtl_related_items mri ,
1631: mtl_system_items_kfv msi ,
1632: po_line_locations_trx_v poll -- CLM project, bug 9403291
1633: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1634: , mtl_parameters mp,
1761: to_char(poh.org_id) FIELD15 --
1762: FROM po_headers_trx_v poh, -- CLM project, bug 9403291
1763: fnd_lookup_values_vl flv ,
1764: po_lines_trx_v pl , -- CLM project, bug 9403291
1765: mtl_related_items mri ,
1766: mtl_system_items_kfv msi ,
1767: po_line_locations_trx_v poll -- CLM project, bug 9403291
1768: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1769: , mtl_parameters mp,
1824: to_char(poh.org_id) FIELD15 --
1825: FROM po_headers_trx_v poh, -- CLM project, bug 9403291
1826: fnd_lookup_values_vl flv ,
1827: po_lines_trx_v pl , -- CLM project, bug 9403291
1828: mtl_related_items mri ,
1829: mtl_system_items_kfv msi ,
1830: po_line_locations_trx_v poll -- CLM project, bug 9403291
1831: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1832: , mtl_parameters mp,
2527: (
2528: SELECT
2529: 'Valid PO Shipments'
2530: FROM po_lines_trx_v pl , -- CLM project, bug 9403291
2531: mtl_related_items mri ,
2532: mtl_system_items_kfv msi ,
2533: po_line_locations_trx_v poll -- CLM project, bug 9403291
2534: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
2535: , mtl_parameters mp,
3021: uom_code
3022: from po_lines_trx_v pl -- CLM project, bug 9403291
3023: , mtl_units_of_measure mum
3024: , mtl_system_items_vl msi
3025: , mtl_related_items mri
3026: where msi.organization_id = p_organization_id -- Bug 6437363
3027: and msi.inventory_item_id = p_inventory_item_id -- Bug 6311550
3028: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE
3029: and pl.po_header_id = p_po_header_id
3051: -- End for Bug 7440217
3052: )
3053: AND pl.line_num LIKE (po_line_number)
3054: AND exists (select 'c' -- Bug 6437363
3055: from MTL_RELATED_ITEMS MRI
3056: where MRI.RELATED_ITEM_ID = MSI.INVENTORY_ITEM_ID
3057: AND PL.ITEM_ID = MRI.INVENTORY_ITEM_ID
3058: union all
3059: select 'c'
3056: where MRI.RELATED_ITEM_ID = MSI.INVENTORY_ITEM_ID
3057: AND PL.ITEM_ID = MRI.INVENTORY_ITEM_ID
3058: union all
3059: select 'c'
3060: from MTL_RELATED_ITEMS MRI
3061: where MRI.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
3062: AND PL.ITEM_ID = MRI.RELATED_ITEM_ID
3063: AND MRI.RECIPROCAL_FLAG = 'Y' )
3064: order by 1;
3517: msi.stock_enabled_flag,
3518: ' ',
3519: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
3520: from po_lines_trx_v pol -- CLM project, bug 9403291
3521: ,mtl_related_items mri
3522: ,mtl_system_items_vl msi /* Bug 5581528 */
3523: /*,mtl_system_items_kfv msia */ /* Bug 6334679*/
3524: where msi.organization_id = p_organization_id
3525: and msi.concatenated_segments like p_concatenated_segments||l_append
4096: msi.stock_enabled_flag,
4097: ' ',
4098: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4099: from po_lines_trx_v pol -- CLM project, bug 9403291
4100: ,mtl_related_items mri
4101: ,mtl_system_items_vl msi /* Bug 5581528 */
4102: /*,mtl_system_items_kfv msia */ /* Bug 6334679 */
4103: where msi.organization_id = p_organization_id
4104: and msi.concatenated_segments like p_concatenated_segments||l_append
4684: msi.stock_enabled_flag,
4685: ' ',
4686: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4687: from po_lines_trx_v pol -- CLM project, bug 9403291
4688: ,mtl_related_items mri
4689: ,mtl_system_items_vl msi /* Bug 5581528 */
4690: /*,mtl_system_items_kfv msia */ /* Bug 6334679 */
4691: where msi.organization_id = p_organization_id
4692: and msi.concatenated_segments like p_concatenated_segments||l_append
5247: msi.stock_enabled_flag,
5248: ' ',
5249: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5250: from po_lines_trx_v pol -- CLM project, bug 9403291
5251: ,mtl_related_items mri
5252: ,mtl_system_items_vl msi /* Bug 5581528 */
5253: /*,mtl_system_items_kfv msia */ /* Bug 6334679 */
5254: where msi.organization_id = p_organization_id
5255: and msi.concatenated_segments like p_concatenated_segments||l_append
5777: msi.stock_enabled_flag,
5778: ' ',
5779: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5780: from po_lines_trx_v pol -- CLM project, bug 9403291
5781: ,mtl_related_items mri
5782: ,mtl_system_items_vl msi /* Bug 5581528 */
5783: /*,mtl_system_items_kfv msia*/ /* Bug 6334679 */
5784: where msi.organization_id = p_organization_id
5785: and msi.concatenated_segments like p_concatenated_segments||l_append
6300: msi.stock_enabled_flag,
6301: ' ',
6302: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6303: from po_lines_trx_v pol -- CLM project, bug 9403291
6304: ,mtl_related_items mri
6305: ,mtl_system_items_vl msi /* Bug 5581528 */
6306: /*,mtl_system_items_kfv msia */ /* Bug 6334679 */
6307: where msi.organization_id = p_organization_id
6308: and msi.concatenated_segments like p_concatenated_segments||l_append
7959: AND msi.concatenated_segments LIKE p_concatenated_segments||l_append
7960: AND (msi.purchasing_enabled_flag = 'Y' OR msi.stock_enabled_flag = 'Y')
7961: AND EXISTS (SELECT '1'
7962: FROM po_lines_trx_v pol, -- CLM project, bug 9403291
7963: mtl_related_items mri,
7964: po_line_locations_trx_v pll -- CLM project, bug 9403291
7965: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
7966: , mtl_parameters mp,
7967: rcv_parameters rp