eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_CATCH_WEIGHT_PVT dependencies on DUAL

Line 86: dual_uom_deviation_high,

82: SELECT NVL(tracking_quantity_ind, G_TRACK_PRIMARY),
83: NVL(ont_pricing_qty_source, G_PRICE_PRIMARY),
84: secondary_default_ind,
85: secondary_uom_code,
86: dual_uom_deviation_high,
87: dual_uom_deviation_low
88: INTO x_tracking_quantity_ind,
89: x_ont_pricing_qty_source,
90: x_secondary_default_ind,

Line 87: dual_uom_deviation_low

83: NVL(ont_pricing_qty_source, G_PRICE_PRIMARY),
84: secondary_default_ind,
85: secondary_uom_code,
86: dual_uom_deviation_high,
87: dual_uom_deviation_low
88: INTO x_tracking_quantity_ind,
89: x_ont_pricing_qty_source,
90: x_secondary_default_ind,
91: x_secondary_uom_code,

Line 1349: SELECT 1 INTO l_temp FROM DUAL

1345:
1346: -- Check LPN that all catch weight enabled items that are not defaultable have sec qty.
1347: -- bug 4918256 only for WDD lines that are part of sales orders (line_direction = 'O')
1348: BEGIN
1349: SELECT 1 INTO l_temp FROM DUAL
1350: WHERE EXISTS (
1351: SELECT 1
1352: FROM mtl_system_items msi,
1353: wsh_delivery_details wdd,

Line 1473: SELECT 1 INTO l_temp FROM DUAL

1469: l_return := G_CHECK_ERROR;
1470: END IF;
1471: ELSE -- Lot controlled item need to check MTLT for sec qty for
1472: BEGIN
1473: SELECT 1 INTO l_temp FROM DUAL
1474: WHERE EXISTS (
1475: SELECT 1
1476: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1477: WHERE mmtt.organization_id = mmtt_item_rec.organization_id

Line 1883: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)

1879: , NVL(msi.LOT_DIVISIBLE_FLAG,'Y')
1880: , NVL(msi.SECONDARY_UOM_CODE,'')
1881: , NVL(msi.SECONDARY_DEFAULT_IND,'')
1882: , NVL(msi.TRACKING_QUANTITY_IND,'P')
1883: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
1884: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
1885: FROM mtl_system_items_kfv msiv,
1886: wms_lpn_contents wlc,
1887: mtl_system_items msi

Line 1884: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)

1880: , NVL(msi.SECONDARY_UOM_CODE,'')
1881: , NVL(msi.SECONDARY_DEFAULT_IND,'')
1882: , NVL(msi.TRACKING_QUANTITY_IND,'P')
1883: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
1884: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
1885: FROM mtl_system_items_kfv msiv,
1886: wms_lpn_contents wlc,
1887: mtl_system_items msi
1888: WHERE wlc.parent_lpn_id = p_lpn_id

Line 1946: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)

1942: , NVL(msi.LOT_DIVISIBLE_FLAG,'Y')
1943: , NVL(msi.SECONDARY_UOM_CODE,'')
1944: , NVL(msi.SECONDARY_DEFAULT_IND,'')
1945: , NVL(msi.TRACKING_QUANTITY_IND,'P')
1946: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
1947: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
1948: FROM mtl_system_items_kfv msi, wms_lpn_contents wlc
1949: WHERE wlc.parent_lpn_id = p_lpn_id
1950: AND wlc.inventory_item_id = msi.inventory_item_id

Line 1947: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)

1943: , NVL(msi.SECONDARY_UOM_CODE,'')
1944: , NVL(msi.SECONDARY_DEFAULT_IND,'')
1945: , NVL(msi.TRACKING_QUANTITY_IND,'P')
1946: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
1947: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
1948: FROM mtl_system_items_kfv msi, wms_lpn_contents wlc
1949: WHERE wlc.parent_lpn_id = p_lpn_id
1950: AND wlc.inventory_item_id = msi.inventory_item_id
1951: AND msi.ont_pricing_qty_source = 'S'

Line 1996: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)

1992: , NVL(msi.LOT_DIVISIBLE_FLAG,'Y')
1993: , NVL(msi.SECONDARY_UOM_CODE,'')
1994: , NVL(msi.SECONDARY_DEFAULT_IND,'')
1995: , NVL(msi.TRACKING_QUANTITY_IND,'P')
1996: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
1997: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
1998: FROM mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt
1999: WHERE (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
2000: AND mmtt.organization_id = p_org_id

Line 1997: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)

1993: , NVL(msi.SECONDARY_UOM_CODE,'')
1994: , NVL(msi.SECONDARY_DEFAULT_IND,'')
1995: , NVL(msi.TRACKING_QUANTITY_IND,'P')
1996: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
1997: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
1998: FROM mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt
1999: WHERE (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
2000: AND mmtt.organization_id = p_org_id
2001: AND mmtt.organization_id = msi.organization_id

Line 2052: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)

2048: , NVL(msi.LOT_DIVISIBLE_FLAG,'Y')
2049: , NVL(msi.SECONDARY_UOM_CODE,'')
2050: , NVL(msi.SECONDARY_DEFAULT_IND,'')
2051: , NVL(msi.TRACKING_QUANTITY_IND,'P')
2052: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
2053: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
2054: from mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt
2055: where (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
2056: and mmtt.organization_id = p_org_id

Line 2053: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)

2049: , NVL(msi.SECONDARY_UOM_CODE,'')
2050: , NVL(msi.SECONDARY_DEFAULT_IND,'')
2051: , NVL(msi.TRACKING_QUANTITY_IND,'P')
2052: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
2053: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
2054: from mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt
2055: where (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
2056: and mmtt.organization_id = p_org_id
2057: and mmtt.organization_id = msi.organization_id

Line 2106: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)

2102: , NVL(msi.LOT_DIVISIBLE_FLAG,'Y')
2103: , NVL(msi.SECONDARY_UOM_CODE,'')
2104: , NVL(msi.SECONDARY_DEFAULT_IND,'')
2105: , NVL(msi.TRACKING_QUANTITY_IND,'P')
2106: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
2107: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
2108: FROM mtl_system_items_kfv msi, wsh_Delivery_Details wdd1
2109: WHERE wdd1.inventory_item_id = msi.inventory_item_id
2110: AND wdd1.organization_id = msi.organization_id

Line 2107: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)

2103: , NVL(msi.SECONDARY_UOM_CODE,'')
2104: , NVL(msi.SECONDARY_DEFAULT_IND,'')
2105: , NVL(msi.TRACKING_QUANTITY_IND,'P')
2106: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
2107: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
2108: FROM mtl_system_items_kfv msi, wsh_Delivery_Details wdd1
2109: WHERE wdd1.inventory_item_id = msi.inventory_item_id
2110: AND wdd1.organization_id = msi.organization_id
2111: AND msi.ont_pricing_qty_source = 'S'