DBA Data[Home] [Help]

APPS.WMS_DIRECT_SHIP_PVT dependencies on INV_CONVERT

Line 4885: ,GREATEST(INV_CONVERT.INV_UM_CONVERT(

4881: ,WDS.TRANSACTION_TEMP_ID
4882: ,WDD.DELIVERY_DETAIL_ID
4883: ,DECODE(WDD.REQUESTED_QUANTITY_UOM,MSI.PRIMARY_UOM_CODE
4884: ,WDD.REQUESTED_QUANTITY
4885: ,GREATEST(INV_CONVERT.INV_UM_CONVERT(
4886: null
4887: ,null
4888: ,WDD.REQUESTED_QUANTITY
4889: ,WDD.REQUESTED_QUANTITY_UOM

Line 5319: ' inv_convert.inv_um_convert(NULL, ' ||

5315: ' , DECODE( ' ||
5316: ' wdd.requested_quantity_uom ' ||
5317: ' , msi.primary_uom_code, wdd.requested_quantity ' ||
5318: ' , GREATEST( ' ||
5319: ' inv_convert.inv_um_convert(NULL, ' ||
5320: ' NULL, wdd.requested_quantity, wdd.requested_quantity_uom, ' ||
5321: ' msi.primary_uom_code, NULL , NULL) ' ||
5322: ' , 0 )) requested_quantity ' ||
5323: ' , msi.primary_uom_code ' ||

Line 8374: ' , GREATEST(inv_convert.inv_um_convert(NULL, NULL, NVL(msn.quantity, wlc.quantity), wlc.uom_code, msi.primary_uom_code, NULL ' ||

8370: ' , wlc.lot_number ' ||
8371: ' , DECODE( ' ||
8372: ' wlc.uom_code ' ||
8373: ' , msi.primary_uom_code, NVL(msn.quantity, wlc.quantity) ' ||
8374: ' , GREATEST(inv_convert.inv_um_convert(NULL, NULL, NVL(msn.quantity, wlc.quantity), wlc.uom_code, msi.primary_uom_code, NULL ' ||
8375: ' , NULL) ' ||
8376: ' , 0) ' ||
8377: ' ) quantity ' ||
8378: ' , DECODE(msi.revision_qty_control_code, 2, ''TRUE'', ''FALSE'') revision_control ' ||

Line 8734: inv_convert.inv_um_convert(NULL, NULL, oel.ordered_quantity, oel.order_quantity_uom, msi.primary_uom_code, NULL

8730: , DECODE(
8731: oel.order_quantity_uom
8732: , msi.primary_uom_code, oel.ordered_quantity
8733: , GREATEST(
8734: inv_convert.inv_um_convert(NULL, NULL, oel.ordered_quantity, oel.order_quantity_uom, msi.primary_uom_code, NULL
8735: , NULL)
8736: , 0
8737: )
8738: ) ordered_quantity

Line 11839: ,GREATEST(inv_convert.inv_um_convert(NULL, NULL,

11835: ,t.INVENTORY_ITEM_ID
11836: ,t.REVISION
11837: ,t.LOT_NUMBER
11838: ,DECODE(t.PICKED_UOM_CODE, msi.primary_uom_code, t.PICKED_QUANTITY
11839: ,GREATEST(inv_convert.inv_um_convert(NULL, NULL,
11840: t.PICKED_QUANTITY, t.PICKED_UOM_CODE, msi.primary_uom_code,
11841: NULL, NULL), 0)) PICKED_QUANTITY_IN_PRI_UOM
11842: ,t.SECONDARY_UOM_CODE
11843: ,t.SECONDARY_QUANTITY