APPS.INV_ITEM_INQ dependencies on WMS_ONHAND_AND_LOADED_QTY_V

Line 1140: from wms_onhand_and_loaded_qty_v

1136: l_packed_quantity NUMBER;
1137: BEGIN
1138: select sum(quantity)
1139: into l_packed_quantity
1140: from wms_onhand_and_loaded_qty_v
1141: where organization_id = p_organization_id
1142: and inventory_item_id = decode(p_inventory_item_id, NULL, inventory_item_id, p_inventory_item_id)
1143: AND nvl(revision, '$@#$%') = decode(p_revision, NULL, nvl(revision,'$@#$%'), p_revision)
1144: AND nvl(lot_number, '$@#$%') = decode(p_lot_number, NULL, nvl(lot_number, '$@#$%'), p_lot_number)

Line 1166: from wms_onhand_and_loaded_qty_v

1162: l_loose_quantity NUMBER;
1163: BEGIN
1164: select sum(quantity)
1165: into l_loose_quantity
1166: from wms_onhand_and_loaded_qty_v
1167: where organization_id = p_organization_id
1168: and inventory_item_id = decode(p_inventory_item_id, NULL, inventory_item_id, p_inventory_item_id)
1169: AND nvl(revision, '$@#$%') = decode(p_revision, NULL, nvl(revision,'$@#$%'), p_revision)
1170: AND nvl(lot_number, '$@#$%') = decode(p_lot_number, NULL, nvl(lot_number, '$@#$%'), p_lot_number)

Line 1198: from wms_onhand_and_loaded_qty_v

1194: select sum(quantity),
1195: sum(secondary_transaction_quantity)
1196: into x_packed_qty,
1197: x_sec_packed_qty
1198: from wms_onhand_and_loaded_qty_v
1199: where organization_id = p_organization_id
1200: and inventory_item_id = decode(p_inventory_item_id, NULL, inventory_item_id, p_inventory_item_id)
1201: AND nvl(revision, '$@#$%') = decode(p_revision, NULL, nvl(revision,'$@#$%'), p_revision)
1202: AND nvl(lot_number, '$@#$%') = decode(p_lot_number, NULL, nvl(lot_number, '$@#$%'), p_lot_number)

Line 1227: from wms_onhand_and_loaded_qty_v

1223: select sum(quantity),
1224: sum(secondary_transaction_quantity)
1225: into x_loose_qty,
1226: x_sec_loose_qty
1227: from wms_onhand_and_loaded_qty_v
1228: where organization_id = p_organization_id
1229: and inventory_item_id = decode(p_inventory_item_id, NULL, inventory_item_id, p_inventory_item_id)
1230: AND nvl(revision, '$@#$%') = decode(p_revision, NULL, nvl(revision,'$@#$%'), p_revision)
1231: AND nvl(lot_number, '$@#$%') = decode(p_lot_number, NULL, nvl(lot_number, '$@#$%'), p_lot_number)