APPS.INV_ITEM_INQ dependencies on WMS_ONHAND_AND_LOADED_QTY_V

Line 1064: from wms_onhand_and_loaded_qty_v

1060: l_packed_quantity NUMBER;
1061: BEGIN
1062: select sum(quantity)
1063: into l_packed_quantity
1064: from wms_onhand_and_loaded_qty_v
1065: where organization_id = p_organization_id
1066: and inventory_item_id = decode(p_inventory_item_id, NULL, inventory_item_id, p_inventory_item_id)
1067: AND nvl(revision, '$@#$%') = decode(p_revision, NULL, nvl(revision,'$@#$%'), p_revision)
1068: AND nvl(lot_number, '$@#$%') = decode(p_lot_number, NULL, nvl(lot_number, '$@#$%'), p_lot_number)

Line 1090: from wms_onhand_and_loaded_qty_v

1086: l_loose_quantity NUMBER;
1087: BEGIN
1088: select sum(quantity)
1089: into l_loose_quantity
1090: from wms_onhand_and_loaded_qty_v
1091: where organization_id = p_organization_id
1092: and inventory_item_id = decode(p_inventory_item_id, NULL, inventory_item_id, p_inventory_item_id)
1093: AND nvl(revision, '$@#$%') = decode(p_revision, NULL, nvl(revision,'$@#$%'), p_revision)
1094: AND nvl(lot_number, '$@#$%') = decode(p_lot_number, NULL, nvl(lot_number, '$@#$%'), p_lot_number)

Line 1122: from wms_onhand_and_loaded_qty_v

1118: select sum(quantity),
1119: sum(secondary_transaction_quantity)
1120: into x_packed_qty,
1121: x_sec_packed_qty
1122: from wms_onhand_and_loaded_qty_v
1123: where organization_id = p_organization_id
1124: and inventory_item_id = decode(p_inventory_item_id, NULL, inventory_item_id, p_inventory_item_id)
1125: AND nvl(revision, '$@#$%') = decode(p_revision, NULL, nvl(revision,'$@#$%'), p_revision)
1126: AND nvl(lot_number, '$@#$%') = decode(p_lot_number, NULL, nvl(lot_number, '$@#$%'), p_lot_number)

Line 1151: from wms_onhand_and_loaded_qty_v

1147: select sum(quantity),
1148: sum(secondary_transaction_quantity)
1149: into x_loose_qty,
1150: x_sec_loose_qty
1151: from wms_onhand_and_loaded_qty_v
1152: where organization_id = p_organization_id
1153: and inventory_item_id = decode(p_inventory_item_id, NULL, inventory_item_id, p_inventory_item_id)
1154: AND nvl(revision, '$@#$%') = decode(p_revision, NULL, nvl(revision,'$@#$%'), p_revision)
1155: AND nvl(lot_number, '$@#$%') = decode(p_lot_number, NULL, nvl(lot_number, '$@#$%'), p_lot_number)